Project Master macro

R

Rod Gill

Hi,

A number of posters recently have wanted a way to consolidate multiple
projects. I've written a simple macro that prompts the user for a folder
then Consolidates all .mpp files in that folder into a new Project.

Visit http://www.msproject-systems.com/Consolidate.htm and download the
project file - use is free but any modifications you might want may need to
be charged for!!

Press Ctrl+m to run the macro, it will ask you to browse to a folder with
your .mpp files
A new file will be created that has a copy of all tasks in each project.
There are no links to the original files (so eliminating any chance of
corruption) and all assignments for each resource will also have been
consolidated.

As usual running the macro on a backup copy of your projects is recommended.
Use of the macro is entirely your responsibility and no liability can or is
assumed by me.
Save a copy of the consolidation weekly for a regular audit trail of your
program of projects.

This is a simple and neat tool that helps demonstrate the power of Project
VBA.
 

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

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Re-title multiple MS Project .mpp files at once 0
Need Help with Macro Security 1
Macro to copy table of contents to a new doc 0
Change a great number of words in word files, with a macro as short as possible. 5
VB Macro export .mpp to .mpp 2
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Using macro to copy template 0

Top