Exporting resource calendars 2

[googli]

Is there an easy way to export multiple resourse calendars out of MS Project. I want to view the non working (vacation time) assigned to resources in one calendar, which I then need to export to Excel.

Is there a report that can be run in MS Project to give this information?

Thanks

 

[PDQBach]

Here's a start:

View | Reports | Customize

In the popup select "Resource" and click on the Edit button

In the popup select the "Details" tab and clear all checkboxes except for Calendar.

If this report is 'generally' what you want but you want to get rid of the extraneous columns like "Material Label", "Initials", etc., then

View | Table:xxxxxx | More tables...
In the popup click on "Entry", click on the "copy" button. Change the name of the table to something like "Entry - Calendar" and delete the rows of data that you don't want. Click on OK then click on Cancel.

View | Reports | Customize

In the popup select "Resource" and click on the Edit button

In the popup select the "Definition" tab and set the Table field to whatever table you defined a moment ago.

And in anticipation of your next question: no, there is no way to print out month-by-month calendars (using the canned report) for each resource.

And in anticipation of your next next question: no, there is no easy way to export this to Excel.

And in anticipation of your next next next question: yes, it could be done in VBA but it will be involved and I don't have a code fragment that can start you on your way.

 

[googli]

Thanks this is a great help.

One minor issue. I can't seem to to see the updated/defined table in the table dropdown field on the defention tab.

Also does anybody have an doce that could start me off. The report returns 300+ pages and it will be labourious to plough through them manually!

Thanks in advance.

 

[PDQBach]

I'm not sure why your table isn't appearing.

Let's try this sequence in greater detail

1. On the main menu bar:
View | Table:xxxxxx | More tables...

This should open a popup window titled "More Tables".

2. In the "More Tables" popup window
click on "Entry",
click on the "Copy..." button.

This should open a popup window titled "Table Definition in 'YourProjectName'"

3. In the "Table Definition" popup window
Change the "Name" field to "PDQ"
You don't have to, but put a check in the box "Show in menu"
In the scroll region below, delete the rows you don't need.
Click on the "OK" button.

This should close the popup and return you to the "More Tables" popup from step 1.

4. You should be able to see a table named "PDQ" in the "More Tables" popup.

Let me know when you get this far successfully.

I don't understand your comment "Also does anybody have an doce that could start me off".

Are you looking for a code fragment? Or is "an doce" something else?

 

[googli]

Aplogies. I meant code.

The table is now appearing. Thanks.

 

[PDQBach]

I, too, would be interested in a code fragment to do this. One of these days I'll have to make another attempt to write it -- unless, of course, someone else here can post a code stub to get us both started.