Edit Paste Special - VBA & Project

[David]

Trying to create a Master Schedule from several projects.
Need only specific tasks from individual projects so I
have a filter created to show them. The macro does this:
1. It opens the individual project
2. It organizes the columns so that they match the Master
3. It searches and counts the number of tasks flagged
4. It runs the filter and then uses EditCopy to copy to
clipboard
5. It then uses EditPasteSpecial Link:=Yes to paste into
the Master.
Problem is that I keep getting intermittent errors.
Usually I get Error "1100". I can run the macro several
times and get to different places each time before it
bombs. It has however ran completely through a couple of
times using the same files in the same directories. The
Master schedule must be linked to the subs of I would just
copy and paste. Any ideas as to what is causing it to bomb?
If there is not enough info to help trouble shoot please
respond and I'll get you what I can.

Thanks,
David

 

[John]

David,
In my opinion, you are asking for trouble if you are using paste links.
It is possible to use them successfully with a lot of patience and
discipline but generally, paste links are very fragile at best and I
suspect some of your problems may be related to using them. Without
knowing exactly what is being paste linked and what method is being used
to do it, it is very difficult to determine what is happening.

As an alternative, why not use external predecessor and successor links
to the specific tasks in each file or build the master using inserted
projects? Either way is much more robust than paste links.

John

 

[Jan De Messemaeker]

Hi,

Whilst agreeing that one should avoid to Paste, it must be said here that it
is the only way I know to copy a task OBJECT with all it holds from one file
to an other one (the alternative being copying the 150 or so properties...)

Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[John]

David,
There are many ways to define the word "see". One way for the customer
to "see" only selected tasks of subprojects is to dynamically
consolidate the subprojects into the master (i.e. insert projects with
linking applied). Then filter the master for the selected tasks.
Everything is linked and all you see are the selected tasks - no macro
required.

If the above is not acceptable, there is a variation I can offer. I have
a macro that will convert a dynamically consolidated master file into a
statically consolidated master file. With some modification, it could be
run after the above filter is applied. The result will be an exact
duplicate of only the selected tasks from the subprojects. If
interested, write me direct.

John

John