Calculate work spent on a task in a month (VBA)

[reinerkuehn]

Hi,
I just started programming in VBA with MS Project 2003.

I want to create an Excel export by using the object model of MS Project.

The export works fine, but how can I get the number of days a team member is working on a task considering a a period (e.g. 1 month) and all the splits and parallel tasks.

I tried the Splitpart object, that shows only the start and finish but not the work :-(.

Example:
A task starts on Nov. 26th with 10d work. The task is splitted into three splits: 11/26-12/02 (5d), 12/15-12/17 (3d), 12/31-01/03 (2d).
Expected result of the calculation: 6d for this task.

I know that I can export the Resource Usage View but this is not the way I want so solve this, because it depends on the view settings.

Thanks,
Reiner

 

[PDQBach]

Either the Resource Usage view or the Task Usage view is the one you want. Then do a copy&paste.

Alternatively, write the VBA code yourself to pull the information out.