Get the Group Summary Dates

[SpaceCamel]

I have applied a grouping to a project showing the virtual summaries. I now
need to get the dates of the group summaries.

I have tried looping thru the tasks looking for the GroupBySummary flag but
nothing is found.

What is the correct way to get the Group Summary task data?

Thanks,

 

[Rod Gill]

Hi,

What about the ActiveProject.TaskGroups collection? Search help for this and
look at related methods and properties.

 

[SpaceCamel]

Iterating thru the TaskGroups collection gives a list of the Project Groups,
not the tasks in the groupings.

Any other ideas? Adding GroupBySummary column does indicate which tasks are
Group Summaries but how does one access the virtual tasks? Iterating thru
the tasks collection skips the Group Summaries. Why do they have the task
property if you can use it?

==============

 

[Rod Gill]

VBA doesn't seem to have a way of getting the totals. Try searching for
group in the Object Browser (press F2 in the VBE).

 

[SpaceCamel]

That is a shame. Grouping can be a powerful feature if only one could access
the virtual summary levels. P3 only has virtual summary groups based on
field values. It allows for an infinite number of structures to make
everyone happy.

--------

 

[Ray McCoppin]

You can read the cell contents by selecting the Row and Column then then read
the cell text. Like that code below.

For x = 1 To ActiveSelection.Tasks.Count
SelectTaskField Row:=x, Column:="Finish"
Debug.Print ActiveCell.Text
Next x

Hope this helps.

 

[SpaceCamel]

Ray,
Were you able to use this to read the virtual Group Summary task values? I
only get normal tasks.

Thanks,