predecessors

G

GR_KIMON

I am making a master project sheet that summarizes many similar sub projects.
Every sub project has internal predecessors. The sub projects use the same
recourse pool. I need to create external predecessors to some tasks of the
successor project to its predecessor project (for example the 2nd project is
related to the 1st and the 3rd project is related to the 2nd and the 4th to
the 3rd etc). This is easy if it is done manually but who can it be done when
you want to use a macro?
THE BIG PROBLEM IS THAT EVERY TIME YOU USE THE MACRO IT DESTROYS THE
INTERNAL PREDECESSORS BECAUSE IT DOSE NOT
ADD THE EXTERNAL PREDECESSORS TO THE INTERNALS. IT REPLACE THE HOLE
PREDECESSOR CELL OF ITS TASK WITH DE RECORDED ONE

please Help!!!
 
J

JackD

This is a common problem with recorded macros. You will have to edit the
macro so that it creates an external dependency while not overwriting the
internal ones.

If you can post your code then someone can show you where it is going wrong.
 
J

John

GR,
A suggestion. Use a spell checker and proofread before you post and,
please don't shout.

If the external predecessor is added to a task that also has an internal
predecessor, depending on how the macro code is structured, you will
need to concatenate the predecessor text strings together. This is done
most conveniently as follows:

[existing predecessor string] & [added predecessor string]

Hope this helps.

John
 

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