Showing summary tasks in a custom text field

[nick1000]

Is there any way of showing a tasks' related summary task name in a custom
text field?

I have detialed tasks at level 4 in MS project, and would like the related
summary task name (level 3) to be automatically populated into text7. Is this
possible?

 

[Jan De Messemaeker]

Hi,

If you can implement a macro, here's one doing that:
sub L4L3()
dim Job as task
for each job in activeproject.tasks
if not job is nothing then
if job.outlinelevel=4 then
job.text1=job.outlineparent.name
end if
end if
next job
end sub

Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[JulieS]

Is there any way of showing a tasks' related summary task name in a
custom
text field?

I have detialed tasks at level 4 in MS project, and would like the
related
summary task name (level 3) to be automatically populated into
text7. Is this
possible?

Hello Nick1000,

Jack Dahlgren (Project MVP) has some sample VBA (Visual Basic for
Application) code posted which when run does close to what you are
seeking. See Jack's code at:
http://masamiki.com/project/macros.htm

Look for the "Summary Name" entry.

Because it is code, you'll have to run the macro when you make a
change, it will not automatically update.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[nick1000]

Jan, Julie,

Thank you very much for the help. I've used Jack's code - and its exactly
what I was after.

Nick

 

[JulieS]

You're welcome Nick. Glad to have helped and thanks for the feedback.

Julie

Jan, Julie,

Thank you very much for the help. I've used Jack's code - and its
exactly
what I was after.

Nick

<snip>

 

[nick1000]

Hi Julie,

I'm wondering if you could help with another query I have? I've posted it as
"Importing Project updates via Excel", and so far had no responses. I'm not
sure if its something you would deal with, but havening no luck so far....

Many thanks
Nick

 

[JulieS]

Hi Nick,
I've responded to your original post.

Julie