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