Project Statistics method

[Terry Montgomery]

Greetings,

This is two questions in one. First what is the field name for the Duration
(%) calculated in the project statistics display box under Project
Information? That field along with Duration Current, Duration Actual &
Duration Remaining are the data elements I want to export out to Excel for
weekly status reports for each project. Is this a Project VBA function I can
do or do I just need the field names to get from within Excel? Tell me how to
do which ever is the easiest.
Thanks,

 

[John]

Greetings,

This is two questions in one. First what is the field name for the Duration
(%) calculated in the project statistics display box under Project
Information? That field along with Duration Current, Duration Actual &
Duration Remaining are the data elements I want to export out to Excel for
weekly status reports for each project. Is this a Project VBA function I can
do or do I just need the field names to get from within Excel? Tell me how to
do which ever is the easiest.
Thanks,

Terry,
What you see are the parameters of the Project Summary Task. You can
access those properties from the ProjectSummaryTask property of the
active project. For example, the % Complete would be:
ActiveProject.ProjectSummaryTask.PercentComplete

Hope this helps.
John
Project MVP

 

[Terry Montgomery]

John,
Thanks for the help. I think I am catching on now. So should I fire this off
inside Project or try and call this property from Excel?
Thanks again.

 

[John]

John,
Thanks for the help. I think I am catching on now. So should I fire this off
inside Project or try and call this property from Excel?
Thanks again.

Terry,
You're welcome. To answer your question, it depends on where the VBA
code resides. The macro can reside in either Project or Excel, it
doesn't really matter which as long as you know and understand the
basics of controlling the objects of one application from another.

In case you are interested, fellow MVP, Rod Gill recently wrote a book
specifically on Project VBA. It is an excellent reference and has many
examples including macros that work between applications. You can find
out more about his book at: http://www.projectvbabook.com

John
Project MVP