locked
How to get/update total resource cost and task information using VBA for MS Project? RRS feed

  • Question

  • I am really very very new to VB. I am trying to develop one small program for a project management consultant. 

    1) There are 2 extra column added for additional information inside MS project plan.

        - One field gives percentage

        - other field gives resource name (e.g. cable) 

    2) This task is also associated with 'Specific Resource' called as 'Cash Outflow'

    3) What I need to do is as follows:

       - Get the total cost of 'dynamic resource name' (in this case cable)  (which I can see from 'Resource Usage')

       - multiply this total cost with percent field 

       - and store it inside the 'Tasks Information' -> 'Resource' -> 'Cash Outflow' -> Unit

    Through VBA I could get hold of all tasks, and loop through it to find 2 additional fields (if not empty). But I am stuck at how to find the total cost for this resource name and also how to update task information ?

    Any help is greatly appreciated,

    regards

    Manisha

    Tuesday, May 5, 2015 1:34 PM

All replies