Project Server 2010 - Create deliverables using VBA RRS feed

  • Question

  • Can anyone tell me how I can use VBA to create project deliverables within a schedule.
    I have specific tasks tagged as deliverables (Enterprise Custom Field) and I need to reflect the Set Deliverable action from VBA. The Deliverable fields are not updateable through VBA hence think I need to call a function to create one?


    Thursday, March 14, 2013 12:04 AM

All replies

  • In the Visual Basic Editor (VBE) press F2 for teh Object Browser. In the search box type Deliverable.

    Click on any result that looks interesting and press F1 for help.

    There is plenty VBA can do with deliverables. Try also recording a macro of you working with Deliverables.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Thursday, March 14, 2013 1:02 AM
  • Thanks Rod

    Used the code below and it worked fine, cheers


     deliverGuid = ActiveProject.Tasks(x).DeliverableGuid
     If deliverGuid = "00000000-0000-0000-0000-000000000000" Then
     SelectRow Row:=x, rowrelative:=False
     TaskDeliverableCreate Create:=True
     SelectRow Row:=x, rowrelative:=False
     TaskDeliverableCreate Create:=False
     End If

    Thursday, March 14, 2013 1:24 AM