Resource weekly hours

[lmontes]

Does anyone know where Project stores the weekly Resource hours for each task?

I'm trying to send this information to Access.

 

[PDQBach]

Without actually writing the code for you, look at:

First, vary cntR from 1 to the number of resources in your project. Within that loop, vary cntA from 1 to the number of assignments for that resource.

For cntR = 1 to Activeproject.resources.count
For cntA = 1 to activeproject.resources(cntR).assignments.count
debug.print activeproject.resources(cntR).assignments(cntA).taskid
Next
Next

 

[lmontes]

Thanks, what about getting the hours for each task weekly?
Is that possible?

 

[PDQBach]

Look up "timephasedata". It'll take too long to explain here but it will have what you're looking for. One gotcha: Project does everything in minutes so when you ask for 1 "day" you'll get 480 which is (8 hours * 60 minutes).