Extract/ Identify Project Summary Level

[Mike]

Hello,

I am trying to pull the PercentComplete and various dates for the first row
(overall project summary line) in numerous project plans, I am having trouble
identifying this Row 0 (or Row 1) in some cases. Is there an easy way to do
this?

Thanks.

 

[Mike]

Sorry...I am doing this in the VBA code; have Project 2002

 

[Guidho]

Activeproject.ProjectSummaryTask should do the trick.

Regards,
Guidho

 

[GMarquez]

'For Project Summary Task, you must to use:

MSProject.ActiveProject.ProjectSummaryTask

'For a common Summary task, you could use:

Dim tTarea As MSProject.Task, _
intSearchedLevelIndentation As Integer

intSearchedLevelIndentation = 1
For Each tTarea In MSProject.ActiveProject.Tasks
If tTarea.Summary _
And tTarea.OutlineLevel = intSearchedLevelIndentation Then
'Your code here
End If
Next