Master project and sub-projects

[Newbie]

Hello,
How can I read the sub-project names with VBA ?
Thanks ahead

 

[Jan De Messemaeker]

Hi,

For each subp in activeproject.subprojects
debug.print subp.name
next

HTH

 

[Newbie]

Hi Jan,
I already tried that syntax, but I'm getting the runtime error 438:
"Property or method not managed by this object".
What's wrong?
Thanks

 

[Rod Gill]

Can you post the code causing the problem and how you have declared each
variable?

 

[John]

Hi Jan,
I already tried that syntax, but I'm getting the runtime error 438:
"Property or method not managed by this object".
What's wrong?
Thanks

Newbie,
There's a little more to the syntax than Jan indicated. Try this instead.
For Each sp in ActiveProject.Subprojects
debug.print sp.SourceProject.Name
Next sp

Be aware however that this will only give the suproject name of the
first indenture of inserted projects. If suprojects are inserted in
other subprojects a different loop structure will be needed.

John
Project MVP

 

[John]

Can you post the code causing the problem and how you have declared each
variable?

Rod,
It's no mystery, see my response.

John

 

[Newbie]

Thanks a lot John!
It works fine! But what a tricky syntax!
Thanks again

 

[John]

Thanks a lot John!
It works fine! But what a tricky syntax!
Thanks again

Newbie,
You're welcome. Just for reference, VBA is tricky indeed, in some cases
the compiler will not require the "Name" property, it will assume it by
default. In other cases, like your example, the full syntax is the only
thing that will make it "happy".

If VBA wasn't tricky, it wouldn't be interesting.

John
Project MVP

 

[Newbie]

<<If VBA wasn't tricky, it wouldn't be interesting.>>

I agree