VBA Macro OutlineShowSubTasks

×

×רז

Hi all
I am trying to write a macro which will scan a master project plan and
filter specific summery tasks (containing a specific string) and then I would
like to expand the summary task’s sub tasks.
I created a filter that filters the summery task (containing the specific
string)
And now I would like to expand the summary task’s sub tasks.
There could be several summery tasks containing the specific string.
I need to run on every summery task.
is there a recommended way of doing it?
The filter is doing its job but I have a problem with the expending sub task
part.
Appreciate your help

Sub In_Progress_Summary_Groups()
ViewApply Name:="Gantt Chart"
FilterApply Name:=" System Engineering_View"
SelectColumn
OutlineShowSubTasks

End Sub
 
J

John

‡¯Ê said:
Hi all
I am trying to write a macro which will scan a master project plan and
filter specific summery tasks (containing a specific string) and then I would
like to expand the summary task’s sub tasks.
I created a filter that filters the summery task (containing the specific
string)
And now I would like to expand the summary task’s sub tasks.
There could be several summery tasks containing the specific string.
I need to run on every summery task.
is there a recommended way of doing it?
The filter is doing its job but I have a problem with the expending sub task
part.
Appreciate your help

Sub In_Progress_Summary_Groups()
ViewApply Name:="Gantt Chart"
FilterApply Name:=" System Engineering_View"
SelectColumn
OutlineShowSubTasks

End Sub
Click to expand...

Person,
This one's a little tricky but all you need to add to your existing code
is the OutlineHideSubTasks statement just before the OutlineShowSubTasks
statement. Why, I don't really know, but that will make it work.

Hope this helps.
John
Project MVP
 
Top