Project Server 2010 - Create deliverables using VBA

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?

Thanks
Sean

Answer 1

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

Answer 2

Thanks Rod

Used the code below and it worked fine, cheers

Sean

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