Convert Master and subprojects into 1 file WITHOUT duplicating predecessors between subfiles

[JB]

Anyone know of a way to convert a Master and it's Subproject files, into one
big mpp file, WITHOUT duplicating tasks that have predecessors between the
subproject files?

Selecting to "unlink" the subprojects doesn't work, because each
cross-project linked task is duplicated when you unlink the schedule.

To see the problem:
1) Create two files containing 2 tasks each. A.mpp and B.mpp
2) Create a Master project containing A.mpp and B.mpp
3) Link A.mpp's task 2 to B.mpp's task 2
4) Save all
5) Unlink the A.mpp summary task, from it's file
a) Double click on the A.mpp summary task (to open the Inserted Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
--- NOTE: There are now 3 tasks in the B file , since the task in B is still
linked to a task in the actual A.mpp file ---
6) Unlink the A.mpp summary task, from it's file
a) Double click on the B.mpp summary task (to open the Inserted Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
Note: Now, instead of linking between the correct tasks, MSP has just made
two duplicate tasks and linked to them.

Any way to get mpp to link to the tasks within the non-linked files?

I know why MSP does this (it retains the file name with the link) I just
want to know how to get around the duplicate task problem, without running
any code.

 

[John]

Anyone know of a way to convert a Master and it's Subproject files, into one
big mpp file, WITHOUT duplicating tasks that have predecessors between the
subproject files?

Selecting to "unlink" the subprojects doesn't work, because each
cross-project linked task is duplicated when you unlink the schedule.

To see the problem:
1) Create two files containing 2 tasks each. A.mpp and B.mpp
2) Create a Master project containing A.mpp and B.mpp
3) Link A.mpp's task 2 to B.mpp's task 2
4) Save all
5) Unlink the A.mpp summary task, from it's file
a) Double click on the A.mpp summary task (to open the Inserted Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
--- NOTE: There are now 3 tasks in the B file , since the task in B is still
linked to a task in the actual A.mpp file ---
6) Unlink the A.mpp summary task, from it's file
a) Double click on the B.mpp summary task (to open the Inserted Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
Note: Now, instead of linking between the correct tasks, MSP has just made
two duplicate tasks and linked to them.

Any way to get mpp to link to the tasks within the non-linked files?

I know why MSP does this (it retains the file name with the link) I just
want to know how to get around the duplicate task problem, without running
any code.

JB,
Yes, but it requires VBA to get what you want. Some years ago I wrote a
VBA macro that converts a dynamically consolidated master file with
links between files into a statically consolidated master with the
external predecessors/successors converted to normal predecessors and
successors. However, the macro is NOT freeware. If you are interested,
write to me direct.

John
Project MVP
jenenj6atatcomcastdotdotnet
(remove obvious redundancies)

 

[JB]

I tried to send a message (replacing atat with @ and dotdot with . ) but the
message didn't go through. Would you please email me?

Anyone know of a way to convert a Master and it's Subproject files, into
one
big mpp file, WITHOUT duplicating tasks that have predecessors between
the
subproject files?

Selecting to "unlink" the subprojects doesn't work, because each
cross-project linked task is duplicated when you unlink the schedule.

To see the problem:
1) Create two files containing 2 tasks each. A.mpp and B.mpp
2) Create a Master project containing A.mpp and B.mpp
3) Link A.mpp's task 2 to B.mpp's task 2
4) Save all
5) Unlink the A.mpp summary task, from it's file
a) Double click on the A.mpp summary task (to open the Inserted
Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
--- NOTE: There are now 3 tasks in the B file , since the task in B is
still
linked to a task in the actual A.mpp file ---
6) Unlink the A.mpp summary task, from it's file
a) Double click on the B.mpp summary task (to open the Inserted
Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
Note: Now, instead of linking between the correct tasks, MSP has just
made
two duplicate tasks and linked to them.

Any way to get mpp to link to the tasks within the non-linked files?

I know why MSP does this (it retains the file name with the link) I just
want to know how to get around the duplicate task problem, without
running
any code.

JB,
Yes, but it requires VBA to get what you want. Some years ago I wrote a
VBA macro that converts a dynamically consolidated master file with
links between files into a statically consolidated master with the
external predecessors/successors converted to normal predecessors and
successors. However, the macro is NOT freeware. If you are interested,
write to me direct.

John
Project MVP
jenenj6atatcomcastdotdotnet
(remove obvious redundancies)

 

[JB]

John,

I tried to send a message (replacing atat with @ and dotdot with . ) but the
message didn't go through. Would you please email me?

JB

Anyone know of a way to convert a Master and it's Subproject files, into
one
big mpp file, WITHOUT duplicating tasks that have predecessors between
the
subproject files?

Selecting to "unlink" the subprojects doesn't work, because each
cross-project linked task is duplicated when you unlink the schedule.

To see the problem:
1) Create two files containing 2 tasks each. A.mpp and B.mpp
2) Create a Master project containing A.mpp and B.mpp
3) Link A.mpp's task 2 to B.mpp's task 2
4) Save all
5) Unlink the A.mpp summary task, from it's file
a) Double click on the A.mpp summary task (to open the Inserted
Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
--- NOTE: There are now 3 tasks in the B file , since the task in B is
still
linked to a task in the actual A.mpp file ---
6) Unlink the A.mpp summary task, from it's file
a) Double click on the B.mpp summary task (to open the Inserted
Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
Note: Now, instead of linking between the correct tasks, MSP has just
made
two duplicate tasks and linked to them.

Any way to get mpp to link to the tasks within the non-linked files?

I know why MSP does this (it retains the file name with the link) I just
want to know how to get around the duplicate task problem, without
running
any code.

JB,
Yes, but it requires VBA to get what you want. Some years ago I wrote a
VBA macro that converts a dynamically consolidated master file with
links between files into a statically consolidated master with the
external predecessors/successors converted to normal predecessors and
successors. However, the macro is NOT freeware. If you are interested,
write to me direct.

John
Project MVP
jenenj6atatcomcastdotdotnet
(remove obvious redundancies)

 

[John]

John,

I tried to send a message (replacing atat with @ and dotdot with . ) but the
message didn't go through. Would you please email me?

JB

JB,
Ooops! I can't spell my own name. Check you e-mail.

John

Anyone know of a way to convert a Master and it's Subproject files, into
one
big mpp file, WITHOUT duplicating tasks that have predecessors between
the
subproject files?

Selecting to "unlink" the subprojects doesn't work, because each
cross-project linked task is duplicated when you unlink the schedule.

To see the problem:
1) Create two files containing 2 tasks each. A.mpp and B.mpp
2) Create a Master project containing A.mpp and B.mpp
3) Link A.mpp's task 2 to B.mpp's task 2
4) Save all
5) Unlink the A.mpp summary task, from it's file
a) Double click on the A.mpp summary task (to open the Inserted
Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
--- NOTE: There are now 3 tasks in the B file , since the task in B is
still
linked to a task in the actual A.mpp file ---
6) Unlink the A.mpp summary task, from it's file
a) Double click on the B.mpp summary task (to open the Inserted
Project
Information dialog box)
b) Click the [Advanced] tab
c) Uncheck [Link to Project]
d) Click [OK]
Note: Now, instead of linking between the correct tasks, MSP has just
made
two duplicate tasks and linked to them.

Any way to get mpp to link to the tasks within the non-linked files?

I know why MSP does this (it retains the file name with the link) I just
want to know how to get around the duplicate task problem, without
running
any code.

JB,
Yes, but it requires VBA to get what you want. Some years ago I wrote a
VBA macro that converts a dynamically consolidated master file with
links between files into a statically consolidated master with the
external predecessors/successors converted to normal predecessors and
successors. However, the macro is NOT freeware. If you are interested,
write to me direct.

John
Project MVP
jenenj6atatcomcastdotdotnet
(remove obvious redundancies)