Consolidate sheets

B

Buster

How would I use VBA to consolidate open projects into one project?

Does anyone or has anyone done this sort of thing?

Jeff
 
R

Rod Gill

Hi,

Record a macro of you doing it manually. I recommend always inserting a
project into another with no link. That way all tasks and assignments etc
are COPIED and resource workloads consolidated across files. It gives you a
snapshot for the week to keep after your reporting is done. Run the recorded
macro each week to recreate a new consolidated file.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz
 
Top