Reading the resource names and percentages via VBA to output to Ex

[Mark VII]

Greetings --

I need to dump the task names, resource names and their percentages to an
Excel file for purposes that would take too long to explain. <g>

Getting code in place to dump out task names and resource names was no
problem -- I just looped through the tasks and wrote out their names, and
looped through the resources and wrote out their names.

What's making me crazy is writing out the percentages (the same ones shown
on the resouce tab of the task information dialog). I can't seem to identify
which property of whick collection.

Any suggestions?

TIA...
Mark

 

[Jan De Messemaeker]

Hi,

Dim Job as task
Dim Asg as assignment
for each job in activeproject.tasks
for each asg in job.assignments
debug.print asg.assignmentunits
next
next

Hope this helps

 

[Mark VII]

Hi Jan --

Tried your suggestion. The only thing I had to change was reading asg.Units
instead of asg.assignmentunits, then it worked like a champ.

Thanks a million for the help.

Mark

 

[Jan De Messemaeker]

Thanks fo rthe feedbzack and sorry for the name of the property - the old
memory sqometimes has a flaw