Full Resource Assignment Info in Excel

[Don]

How can I get the data (summary by resource by project together with the hours assigned by month) as shown in the Resource Usage view in Excel? It's easy to get the summary data from the "View resource assignments" Summary view in the Resources Center of PWA, but I want the hours by month for each resource by project as well.

Thanks!

 

[John]

Don,
Have you tried the "analyze timescaled data in Excel" add-in? If not, it
is on the Analysis toolbar. This will get the timescaled hours by
resource assignment but not by project (at least directly). However, you
can export the static data (i.e. resource by project) by using an export
map. The data can then be combined in Excel.

Or, a more automated way is to write a custom VBA macro that exports all
the data and formats it in Excel in one operation.

Hope this helps.
John

 

[Don]

Thanks John. Where can I find documentation of the Project Server object model and/or sample VBA code to get me started with this? I understand there's also a Project Server SDK?

Thanks again!

 

[John]

Don,
I don't have Project Server so I don't know how the server object model
differs from the standard object model. However, like the object models
for all versions of Project, they generally are pretty constant except
for added features and a few deleted items. I get all of my object model
information from the object model help files available through the VBA
editor. But for your reading (and learning) enjoyment here are some
websites you may find useful.

One nice place to start with sample VBA code is Jack Dahlgren's website:
http://masamiki.com/project/macros.htm

For a free Project 2002 VBA training module (equally applicable to
Project 2003) put together by Microsoft (for VBA, see module 4):
http://support.microsoft.com/default.aspx?scid=kb;en-us;325846

For a Project 2002 and 2003 SDK:
http://www.mvps.org/project/links.htm

Hopefully this info will get you started. Once you get started if you
have further questions on VBA, just post on the
microsoft.public.project.developer newsgroup.

John