Calendar- exporting

H

Helge Svee

Is there a way to export non working days from project calendar to ig excel
og word
 
J

John

Helge Svee said:
Is there a way to export non working days from project calendar to ig excel
og word

Helge,
Sure, but it depends on what you mean by "...export non working
days...". For instance, do you simply want a list of those days, do you
want a formatted report, or what? Either way it most likely will require
the use of VBA.

John
Project MVP
 
H

Helge Svee

Yes I simply want a list of those days. Under reports I find a report which
is a print out of calendar settings, but not dates... I wondered about a way
to format this report to give me a list of days..

John skrev:
 
J

John

Helge Svee said:
Yes I simply want a list of those days. Under reports I find a report which
is a print out of calendar settings, but not dates... I wondered about a way
to format this report to give me a list of days..

John skrev:

Helge,
To get the type of report you want VBA will be required. I would
probably use the Months Collection Object in a loop with the Days
Collection Object and look at the Working Property. I would then export
the information to Excel and format a list or report.

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top