Retrieving summary name for a task

[Clark]

I am trying to retrieve summary task names for tasks that are below them in
the work breakdown structure. I need to be able to select 2 of the summary
task names that are "above" each task. For example, if I have a task at WBS
1.2.3.4.5, I might need to retrieve the summary task name for WBS 1.2 and
1.2.3. I am novice with VBA, so I would greatly appreaciate anything you can
do to point me in a reasonable direction.

Thanks

 

[Jan De Messemaeker]

Hi,

Thetask.outlineparent.name
Thetask.outlineparent.outlineparent.name
HTH

 

[Clark]

Thanks. This got me one step closer. The example you provide below returns
the immediately preceding parent summary task name and its parent summary
task. In the WBS, if I use your approach for task 1.2.3.4.5, it will return
(respectively) the summary task names for:
1.2.3.4
1.2.3

The challenge I have is to retrieve this information for a WBS that is at a
variety of levels (I may have lowest level tasks at 1.2.3.x and others at
1.2.3.4.5.6.7.x). In all cases, however, I need to return two summary tasks
at the same level of the WBS. For illustration, I need the following two
levels:

_.a.b
_.a

For task 1.2.3.x, this would return the summary name for

2.3
2

For task 1.2.3.4.5.6.7.x it would also return the name for

2.3
2

For task 9.3.4.5.6.7.x, it would return the name for

3.4
3

My guess is that I am going to have to run through a loop of some sort to
iterate until I "find" the right values, but I was hoping for a quick way to
get there.

Thanks again for the quick response and moving me closer to the end.

 

[JackD]

A perfect case for recursion.
Here is an example which does most of what you want:
http://zo-d.com/blog/archives/programming/recursion-in-project-vba.html
What you need to do is put some statement in the recursion routine so it
stops at the correct level. You would probably test for task.outlinelevel
and if it is at a certain level (sounds like you want 2 and 3) then you
would return the value.