Export to Excel

[ProjectUser]

How do I export timephased data to excel in order to have subgroup totals and
names? At the moment the only way to have something like Resource name,
Project name, Task name and their totals (like Work, Cost, etc.) is trough
Save as Excel Pivot table, but this doesn't allow to export timephased data.
If on the other side I export timephased data I can't get any subtotal or
grouping possibility.

 

[John]

How do I export timephased data to excel in order to have subgroup totals and
names? At the moment the only way to have something like Resource name,
Project name, Task name and their totals (like Work, Cost, etc.) is trough
Save as Excel Pivot table, but this doesn't allow to export timephased data.
If on the other side I export timephased data I can't get any subtotal or
grouping possibility.

ProjectUser,
There are basically two approaches. If you feel daring, you could get a
copy of the code for the "analyze timescale data in Excel" utility and
modify it to do what you need. If I recall the code can be downloaded
from:
http://microsoft.com/downloads/details.aspx?FamilyId=A7E06469-ED3E-4DAB-8
EFD-4BAE1B918EC3&displaylang=en

Personally I find the code rather convolved and difficult to follow. The
other method is to write your own VBA macro to export the data. If you
don't know VBA but would like to learn, go to our MVP website at:
http://www.mvps.org/project/links.htm
and look for the link at the bottom of the page for, "Project 98 Visual
Basic Environment Training Materials". Even though it says it is for
Project 98, it is equally applicable to all current versions of Project.

If you would like to see a sample of code that exports data from Project
to Excel, try visiting fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
and look at Jack's macro, "Export hierarchy to Excel".

Hope this helps.
John
Project MVP