Resource calendar information

[Sarah]

All,

One group in our company uses a shared resource pool in MS Project
2000. I have VBA code that formats availability information in Excel,
which works for my group, as the schedules are not permanently linked
to the resource pool. But if we use the "Analyze Timescaled Data in
Excel" add-in to extract the information from the other group's shared
resource pool, it's pulling availability relative to all currently
linked project schedules. I just want it to show availability based on
the resource calendars. Can anyone tell me how to export the resource
calendar? We want to create a report that shows what out of office
time the resource pool currently contains for each resource, for a
given time period, so they can validate it at the beginning of each
month.

Thanks!
Sarah
sarah_kiko@(removethis)cinfin.com

 

[Gérard Ducouret]

Hello Sarah,

A VBA procedure could read the resource calendar :
Ex: where Ress is the name of a resource :

If ThisProject.Resources(Ress).Calendar.Period(Deb + i, Fin).Working = False
Then

Hope this helps,

Gérard Ducouret