Milestone Reports from Several Non Related Projects

[Jan De Messemaeker]

Hi,

In a new project, Insert, Project... each of the 50 files.
That does exactly what you need
HTH

 

[Craig]

Hi,

Currently my client tracks the milestone tasks of separate MS Project files
by creating one Excel file with each spreadsheet acting as a milestone report
for each project....the Projects are not connected. He has to do it
manually...go into each of 50 sheets (that are in 1 Excel file) once a month
and updating milestone tasks by either entering the new scheduled dates one
at a time or by color coding small cells to make it appear like a Gantt bar.

Is there any way to produce one batch of Milestone Reports in Project or
Excel that are automatically tied to the other project tasks in each
respective MS Project? ...that is, the milestone dates (text or perhaps Gantt
bars...but at least date text) would change automatically in the report when
other tasks change? The key is to have the batch of Milestone Reports in one
electronic file (not hard copy) that upper management can review easily to
see the status of product development for each project? So I cant just tell
him to go into 50 MS Project files and print out a separate Milestone Report
for each project.

Thank you very much for any insight into this problem!

Regards

Craig

 

[j0j0]

How well does this system work, particularly if you have large projects and
lots of them!?!?!

 

[j0j0]

How well does this system work, particularly if you have large project and
many of them!?!?!

 

[Rod Gill]

Hi,

Inserting projects will certainly work, but maintaining 50 projects linked
to a master without damaging a link and so corrupting one or more files will
be difficult. I would either write a macro to read data and update an Excel
report, or have a macro to automatically create a consolidated project by
inserting projects with NO link. That way all tasks are copied, snapshot
created and assignments for resources merged. You can then filter for
milestones.

A few mods to the macro would add extra reporting.

Alternatively you can have a macro read milestones in Project then export to
Excel.

With Project Server, of course, this is just a matter of adding a View to
Project Web Access and you will get what you need automatically!

 

[Rob Schneider]

Based on my experience, 50 shouldn't be a problem. I guess that your
machine should have sufficient (512 mb or greater) memory and free disk
space. Project takes care of the rest.