Accessing Project Summary Task fields in VBA

[tbone]

I'd like to be able to copy over certain fields from a subproject into
the Master project. The Master project's Calculate event is called
when a subproject is added, so this is the perfect time to do this.

However, the info I want to bring over is from the subproject's
project summary task (line 0) and I don't see how to access that info.

Thanks
tbone

 

[John]

I'd like to be able to copy over certain fields from a subproject into
the Master project. The Master project's Calculate event is called
when a subproject is added, so this is the perfect time to do this.

However, the info I want to bring over is from the subproject's
project summary task (line 0) and I don't see how to access that info.

Thanks
tbone

tbone,
Pretty straightforward. Properties of the project summary task are
accessed using:
ActiveProject.ProjectSummaryTask.[property]

This information is readily available by using the object browser in the
VB Editor.

John
Project MVP

 

[tbone]

John,

Thanks. I forgot about using the Object Browser.

tbone

I'd like to be able to copy over certain fields from a subproject into
the Master project. The Master project's Calculate event is called
when a subproject is added, so this is the perfect time to do this.

However, the info I want to bring over is from the subproject's
project summary task (line 0) and I don't see how to access that info.

Thanks
tbone

tbone,
Pretty straightforward. Properties of the project summary task are
accessed using:
ActiveProject.ProjectSummaryTask.[property]

This information is readily available by using the object browser in the
VB Editor.

John
Project MVP

 

[John]

John,

Thanks. I forgot about using the Object Browser.

tbone

tbone,
You're welcome. The object browser is the first place I always go when I
need info on VBA syntax.

John
Project MVP

I'd like to be able to copy over certain fields from a subproject into
the Master project. The Master project's Calculate event is called
when a subproject is added, so this is the perfect time to do this.

However, the info I want to bring over is from the subproject's
project summary task (line 0) and I don't see how to access that info.

Thanks
tbone

tbone,
Pretty straightforward. Properties of the project summary task are
accessed using:
ActiveProject.ProjectSummaryTask.[property]

This information is readily available by using the object browser in the
VB Editor.

John
Project MVP