Re: Milestone Reports from Several Non Related Projects

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!

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:Oj97T2Q0GHA.3512@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

In a new project, Insert, Project... each of the 50 files.
That does exactly what you need
HTH
--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Craig" <Craig@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:D26694F6-25BB-4E5A-BA29-165A32D1E6C3@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Date range on reports
    ... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Without knowing where your report parameters were coming from, ... >>> open an Access database or an Access project. ... >>> In the New Form dialog box, click Design View, and click OK. ... >>> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: D3 Output processor macros
    ... Actually I'm creating a pretty good looking report with OP. ... that I found has to do with the .TCL command. ... ..TCL command was inserting 'extraneous' form-feeds in the middle of the ... > macro that can be inserted anywhere with identical results. ...
    (comp.databases.pick)
  • Re: A question about converting text to excel and automatically searching data
    ... Creating a worksheet from a text file. ... Writing the macro might be a little bit tricky, though, depending on how ... Creating your report. ... > formula if needed and placed in the proper cell of the main report ...
    (microsoft.public.excel)