Print multiple projects at once

[ARBrock]

Hi,

I update and print 30-50 project calendars every week. Any hints on how to
write a macro that will go through a specified folder and print the calendar
view for a user-specified date range?

Thanks!

-AR

 

[ARBrock]

If it is easier... can we run VBA that will print all of the open projects
for a user-specified range?

 

[Scudder]

You can either.

I'm assuming your not using project server, in which case you ideally need a
single drop point (a folder) for your project files.

You then have a couple of options:

Code a MS project macro with a reference to the MS File System Object, use
this to establish the MPP files in your drop point folder. Open each mpp
file, set the view, assign the print temporal window and print. Then close
the mpp and on to the next one.

Alternatively you could code this standalone with VB or a .Net language
referencing the MS Project object model and performing the same actions. This
would be preferable if there are other PMO type actions you wanted to carry
out.

Finally you could build an addin of course.

But it is very straightforward.

- a good point is to save the view when the mpp is opened and restore it
before you close, otherwise your PM's might start grumbling about having to
switch views.

Lee.