(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Hail denizens of this planet !
Sometimes the need arises for a schedule made up of selected activities from various other schedules (dynamically linked of course). But so far the only way workaround I could come up was by creating a master (inserting sub projects) and then using filters/flags etc and saving that view.
Is their a more direct way to do this : where MS Project lets you select which activities to insert from a subproject ?
Printer-friendly version
Send to friend
Suleiman,
(Assuming you're working outside of Project Server or Project Online.) Inter-project links in MSP rely on the file system, so they can be touchy. They also get multiplied each time a file is saved off or copied. For your P1/P2/P3 --> Px case, here are the options I see (none are ideal).
1. Manual copy-paste with dynamic (file system-based) updating. i.e. Create project Px and manually copy-paste the tasks you want from P1/P2/P3 into Px. Then either:
a. (Logic Links) Insert all 4 projects into a temporary linked master shell, then use click and drag to create the logic links from P1/P2/P3 into Px. You can delete the master after "saving changes" to the four sub-projects. This will make the schedule data only (not the custom fields etc) dynamically linked.
b. (OLE Links) Open all 4 files. Then one cell at a time, Copy-Paste Special-PasteLink the specific task values from the P1/P2/P3 files to the corresponding task cells in Px.
2. Write a procedure (in VBA) to dynamically create or update Px using the flagged tasks from P1/P2/P3. (You'd have to decide on a few things....) Rod Gill's book on VBA programming for MSP includes some good examples. After generally unsatisfying though not terrible experiences with file system-based links, this is what I would do.
Good luck, tom
Hi Suleiman
If you cant open the projects in one file then you can't cross link.
Unless MSP has a much superior way of linking between files.
Best regards
Mike Testro
Hi Mike,
Thanks for your detailed answer. It is a great workflow.
I alreday have , for eg, three project files : p1, p2 and p3
I want to insert only SOME activities from them into a new schedule called px.
This needs to be dynamically linked so copy paste is not an option.
Hi Suleiman - Welcome to planning planet.
I Asta PowerProject you can have any number of open projects in one file and link tasks between projects.
When planning a new project I have a library of pre planned sections which I just copy - paste intothe master programme.
Whenever I have a completely new section of work I copy the section back into the library for when it is needed again.
Obviously each new import is checked and adjusted for the exigencies of the new project.
Using this method I can usually complete a tender programme in under 8 hours.
I suppose tis is similar to your Franenstein concept.
Best regards
Mike Testro
Email: PPadmin@planningplanet.com
Replies