Timescaled Values for Project Summary Task

[RobV]

Does the project summary task have timescaled values associated with it? I
am having trouble pulling them off and have started to wonder if they are
stored.

 

[John]

Does the project summary task have timescaled values associated with it? I
am having trouble pulling them off and have started to wonder if they are
stored.

RobV,
Yes the Project Summary Task does have timescaled values and yes, you
can extract them via VBA. If you are having trouble extracting that data
it is probably because your code is not setting the Project Summary Task
as the current object. For example, if you are using the standard, "For
Each t in ActiveProject.Tasks" loop syntax, it will not pick up the
Project Summary Task which is task ID "0". Try selecting all tasks and
then using the, "For Each t in ActiveSelection.Tasks" loop syntax.

Or, you could set the Project Summary Task as an object,
Set t = ActiveProject.ProjectSummaryTask
and then apply the timescaledata method to that object.

Hope this helps.
John
Project MVP

 

[RobV]

John, you diagnosed what was happening perfectly. I used your second option,
and it worked like a charm. Many thanks.

 

[John]

John, you diagnosed what was happening perfectly. I used your second option,
and it worked like a charm. Many thanks.

RobV,
You're welcome and thanks for the feedback.
John