Exporting/extracting data from resource calendars

[bob]

Does anybod know how to export/extract non working time from resource
calendars? I need to summerise all the vacation time (non working time) for a
number of resources.

Thanks

 

[Jan De Messemaeker]

Hi Bob,

The only way I know is through a VBA procedure.
HTH

 

[bob]

do you know if there is a report that can be run to show all the non working
time for all the resources. I just need to see all the vacation time for all
the resources.

 

[Jan De Messemaeker]

Hi,

If I knew a report, would I say "the only way I know is through a VBA
procedure"?
So the answer to this one is no, sorry.

 

[Andrew Lavinsky]

This might do it:

View > Reports > Custom > Resources, pick "edit", select the "detail" tab,
and make sure "Calendar" is selected. This will create a list of calendar
exceptions to each resource.

Maybe that's what you're looking for?

-A

 

[Jan De Messemaeker]

My apologies. Thought there was no solution.
I've learned something.

 

[bob]

Would it be possible for you to share the procedure with us?

Thanks.

 

[Jan De Messemaeker]

Hi,

I don't have a store with snippets at hand; if I have the time I'll re-write
something tomorrow (it is now late evening in Western Europe)

 

[Jan De Messemaeker]

Hi Bob,

Just realized that the logic of recognizing individual resource's free days
is embedded in the macro you can find under MS Project: an abstract on my
website

Key is tocompare, fore each day, the period.working property of both the
base calendar and the resource calendar
Hope this helps,