"Export to Excel" by Jack Dahlgren

[scott_hanebutt]

I am wanting to know how to add the Project Summary line to the Excel file in
"Export to Excel" by Jack Dahlgen.

Thanks,
Scott Hanebutt

 

[John]

I am wanting to know how to add the Project Summary line to the Excel file in
"Export to Excel" by Jack Dahlgen.

Thanks,
Scott Hanebutt

Scott,
I assume you are referring to Jack's macro called, "export hierarchy to
Excel". In the second "For Each t in ActiveProject.Tasks" loop use the
ProjectSummaryTaskProperty. For example the following line will give the
Task Name for the Project Summary Task:
PSTName = ActiveProject.ProjectSummaryTask.Name

Use the same construct for other fields of the Summary Task.

Hope this helps.
John
Project MVP

 

[JackD]

Yep.
Scott, you will benefit from opening the project help and reading about the
object model.
Once you understand it you can do just about anything, or at least know when
what you want to do is impossible.