SubProject Calendars

[Shadowblu]

How do I get to the SubProject Calendars?

I have a VBA macro that will output to Excel a list of
resources that have nonstandard days on their calendars. I
am trying to convert this macro to be used with a master
project (containing several linked subprojects).

Here is the code for the start of my resource calendar
reference:
For Each R In ActiveProject.Resources()

In this case, I need a way to change this from
ActiveProject which equates to the master project file to
the individual subproject resource calendars.

Any ideas?

Thank you for your help and feedback.

Laura

 

[Robert Pickford]

You need to do the following:
For Each subp In ActiveProject.Subprojects
Dim proj as Project
Set proj = subp.SourceProject
For Each R in proj.Resources
.....

Cheers,
Robert

 

[Shadowblu]

Fantastic! It worked great! Thank you so much!

Laura