Macro for Exporting Resource Usage View to Excel

[Cole]

Question:

I'm looking for a Macro to export the Resource Usage View to Excel

I understand the 'Analyze Timescaled Date Wizard' will give me the
month by month hours for each resource, but I'm also looking for the
list of resources and the amount of time they're spending on tasks over
a period of time to and Excel file.

With the amount of inquires and request on this matter, I have to
believe someone out there has written a macro for this function. I am
hoping that individual would be willing to share that information with
me.

Any thoughts?

Cole
(e-mail address removed)

 

[John]

Question:

I'm looking for a Macro to export the Resource Usage View to Excel

I understand the 'Analyze Timescaled Date Wizard' will give me the
month by month hours for each resource, but I'm also looking for the
list of resources and the amount of time they're spending on tasks over
a period of time to and Excel file.

With the amount of inquires and request on this matter, I have to
believe someone out there has written a macro for this function. I am
hoping that individual would be willing to share that information with
me.

Any thoughts?

Cole
(e-mail address removed)

Cole,
The utility "analyze timescaled data in Excel" will of course export
data in a variety of time periods, not just monthly. And it certainly
gives the list of resources so I'm not sure what else you want.

I personally write a fair number of custom macros to export Project data
to Excel but they are all for specific needs of clients. The majority
are not freeware but regardless, they are not general and would need to
be modified to suit another user's needs. Of course I can only speak for
myself, maybe one of the other guys has something for you.

John
Project MVP