Discussion:
Accessing Project Summary Task fields in VBA
(too old to reply)
tbone
2010-02-02 15:05:54 UTC
Permalink
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
2010-02-02 15:26:45 UTC
Permalink
Post by 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
tbone
2010-02-02 15:54:31 UTC
Permalink
John,

Thanks. I forgot about using the Object Browser.

tbone
Post by John
Post by 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
ActiveProject.ProjectSummaryTask.[property]
This information is readily available by using the object browser in the
VB Editor.
John
Project MVP
John
2010-02-03 00:45:29 UTC
Permalink
Post by tbone
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
Post by tbone
Post by John
Post by 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
ActiveProject.ProjectSummaryTask.[property]
This information is readily available by using the object browser in the
VB Editor.
John
Project MVP
Loading...