Automating splitting of master schedule into several schedules...

[wendyB]

I have been working with a very large schedule comprising of sections of
several discrete projects with interdependencies among these sub-projects and
I am now at the point where the project owners would like to have the
"master" split into several smaller sized schedules and so that each one
could manage their own schedule. Assuming that publishing these
sub-schedules into MS Project Enterprise isn't going to eliminate the need
for cross-linking the dependencies among the what would be resultant
sub-schedules (correct me if I'm wrong), is there a way to automate the
splitting up of a master into several individual .mpp files with
cross-dependencies without losing the precedessor/successor information?

Thanks in advance.

 

[John]

I have been working with a very large schedule comprising of sections of
several discrete projects with interdependencies among these sub-projects and
I am now at the point where the project owners would like to have the
"master" split into several smaller sized schedules and so that each one
could manage their own schedule. Assuming that publishing these
sub-schedules into MS Project Enterprise isn't going to eliminate the need
for cross-linking the dependencies among the what would be resultant
sub-schedules (correct me if I'm wrong), is there a way to automate the
splitting up of a master into several individual .mpp files with
cross-dependencies without losing the precedessor/successor information?

Thanks in advance.

wendyB,
I know nothing about Project Server so I don't know if there are options
to do what you want. I do know however that what you want can be
accomplished, in automated fashion, by using VBA. I have a macro (not
freeware) that does the opposite of what you need. It should be possible
to basically reverse the process for your needs. If you are interested,
write me direct.

John
Project MVP

 

[Brian K - Project MVP]

I have been working with a very large schedule comprising of sections
of several discrete projects with interdependencies among these
sub-projects and I am now at the point where the project owners would
like to have the "master" split into several smaller sized schedules
and so that each one could manage their own schedule. Assuming that
publishing these sub-schedules into MS Project Enterprise isn't going
to eliminate the need for cross-linking the dependencies among the
what would be resultant sub-schedules (correct me if I'm wrong), is
there a way to automate the splitting up of a master into several
individual .mpp files with cross-dependencies without losing the
precedessor/successor information?

Thanks in advance.

Sorry but no there is not a way to do this.

It could be written but it would take about 200 times longer to write a
macro to do this for you than it would to just do it.

 

[wendyB]

Thanks, Brian - I thought so too, but just wanted to know what other's
experiences might have been.

 

[keng]

John.
Are you saying that you have a macro that will combine multiple sub-projects
back into a single project and will grab all the links and keep them? If so,
I'd like to get a copy of that macro. I'm struggling trying to recombine a
large file and don't want to retype it all in. Please let meknow. Send me
an email at (e-mail address removed) and we can converse offline.

Thanks
Ken