Inserted Tasks?

[Greg]

Can specific tasks from different Project files be
inserted into a single master file instead of inserting
each entire Project file?

 

[Rod Gill]

Hi,

No. You can do copies via VBA. I usually set a Flagn field (EG Flag1) to Yes
for all tasks I want reported on in a master report then do a temporary
consolidation (without linking). That copies all task data and consolidates
resource information. I then filter for all tasks with Flag1=Yes and there's
my report. I delete the new master when finished, or over-write with a new
consolidated copy next week. It's also very easy to record a macro of me
creating the consolidated file for running each week.

--
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.projectlearning.com/

 

[Guest]

Thanks, I'll give it a try.

Greg

-----Original Message-----
Hi,

No. You can do copies via VBA. I usually set a Flagn field (EG Flag1) to Yes
for all tasks I want reported on in a master report then do a temporary
consolidation (without linking). That copies all task data and consolidates
resource information. I then filter for all tasks with Flag1=Yes and there's
my report. I delete the new master when finished, or over- write with a new
consolidated copy next week. It's also very easy to record a macro of me
creating the consolidated file for running each week.

--
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.projectlearning.com/



.

 

[John]

Greg,
The simple answer is yes but the methods to get there may not be what
you had in mind. First, a quick explanation about "inserting" projects.
When a dynamically consolidated master is created, (i.e. inserted
projects with links to the subprojects), the subprojects are not
physically inserted into the master. Rather a pointer for the
subrproject is inserted and the pointer of necessity is for the whole
subproject file. So in the strict sense, it's all or nothing. However
there are a couple of ways to "insert" parts of a subproject. The most
obvious, although least desireable, is to simply cut and paste selected
subproject tasks into the master. This is of course a "snapshot"
solution because the pasted tasks are not linked to the subproject.

Another method that may be worth trying if you don't have too many
tasks. Set up a series of milestones in the master project and use
external links to "attach" them to selected tasks in the subprojects.
This will provide a dynamic link but can be rather cumbersome.

There are probably other ways to get there depending on what the end
goal is and how much complexity is acceptable (i.e. VBA approaches)

Hope this helps.
John