Export timescaled data by task, resource

[Kevin]

Hi,

I'm tring to export project's data into Excel by task and resource.
The output would be like
week1 week2
task1
Kevin 3
task2
Trevor 6
task3
Kevin 2 4
Trevor 4

I'm struggling to get the resource usage for a specific task (i.e. 3 for
Kevin for task1).

Does anyone know how to get the resource usage for a specific task?

Thanks

Kevin

 

[Rod Gill]

Hi,

You need to export Assignment timephased data. Find the right Resource, then
use the TimeScaleData method to return your data week by week.

My book actually covers this (and the process of exporting to Excel) in
detail.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Kevin]

Thank you Rod!!!
With your advice, I made it work!

 

[MarkP]

Rod,

I'm trying to export to excel and seem to have run into an issues.

I cu & Pasted your sample code here:

Set TSV = r.TimeScaleData(StartDate:= _
ActiveProject.ProjectSummaryTask.Start, _
EndDate:=ActiveProject.ProjectSummaryTask.Finish, _
Type:=pjTaskTimescaledWork, _
TimeScaleUnit:=pjTimescaleMonths, Count:=1)

but MS Project 2007 give me this error:

"Run-time error '1101':
The argument value is not valid"

When I remove the "Type" paramenter, the code works GREAT.

Any suggstions ?

- MarkP

 

[Jan De Messemaeker]

Hi,

Indeed, a resource cannot have tasktimescaledwork! (and I suppose R stands
for a resource object)
If you want to use the work "for a task done by a resoruce" that is neither
a task nor a resoruce but an assignment.
Define your assignment anss use assignmenttimescaledwork.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf