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
 

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

Top