dependencies in a macro

[Laura]

A while ago, I created a macro that had assigned three sub-tasks to a larger
task. The macro also assigned dependencies - task 2 was dependent on the
completion of task 1 and task 3, dependent on the completion of task 2. I
tried to recreate the macro and cannot seem to recreate the relative
dependencies. So in my macro, task 2 is dependent on the completion of task
1 for the first time the macro is run, but then if I run the macro later,
task 10 is dependent on task 1, rather than task 9. I have relative value
selected for rows and fixed value selected for columns. Can someone help me
figure this one out? Thanks

 

[Jan De Messemaeker]

Hi Laura,

A while ago, you posted this and I did reply, be it in principle.
Can you explain EXACTLY what you want, I'll give you the code.

For instance is it:

I want selected tasks to be linked FS to one another, the 2nd to the 1st,
the 3rd to the 2nd, etc.
If it isn't this how exactly would you phrase your requirement?

 

[Paul S]

I have a related and challenging question:
I will be collecting project plans from about 8 people. I will paste their
plans into one big one. not all but many tasks are prefixed with SEND and
others with RECEIVE (inter project dependencies) each set of SEND and
RECEIVES have used one of the UserText fields with a dependency id (DEP ID).

how can I match up the SEND/RECEIVE with the same DEP ID and make the
RECEIVE task a dependency of the SEND task?

Paul

 

[Jan De Messemaeker]

Hi,

Some thoughts as they come to mind:

This is a nice subject for a VBA procedure that can be quite challenging
indeed.

I suppose that apart from the ID you als have an indication of which project
this dependent task belongs?

Your system is very vulnerable as one change in the numbering of tasks (f.i.
a new task) is not reflected in the Text fields which then show utter
nonsence.

Would you really paste the task lists in teh new project? Are you aware that
Insert, Project with link to Project off is a far more elegant solution to
this?

Do you wite VBA? Is there a specialist around?
I this is a one-off thing it is much easoier to build teh links between
projects instaed of entering text fields and then have a (rather complex)
procedure do it automatically.

I can help you out with specific aspects of the code, but a VBA course
really is too big for a posting in a Newsgroup.

Greetings,

 

[Paul S]

Jan,
I will read up on the Insert Project Link. My described method has worked
in the past due to having a small subset of tasks in the PMO version of the
Program - under 1000 tasks and a PCO manually linked the dependencies of
which there were only about 100.

Paul S