lepton
01-12-2011, 09:30 PM
Hi all,
I like to develop a macro which reads all rows of a MS Project files which contains references to other MS Project files. The reason is that I do have a big schedule which is composed of 6 sub-schedules (ms project files) which the project managers change independently.
I do have:
- 1x master file
(containing project management functions and references to other MS project files which can be opened by expanding them in the master file)
- 6x sub schedules
The macro is part of the master file.
The problem:
'does return only the tasks of the master file
Set taskList = ActiveProject.Task
Does somebody have an idea how I can read the tasks of the referenced files as well? Do I have to manually open them? If yes, how can I do that and can I get all tasks in one list to be able to go through them with a for loop?
Many thanks in advance!
Lep
I like to develop a macro which reads all rows of a MS Project files which contains references to other MS Project files. The reason is that I do have a big schedule which is composed of 6 sub-schedules (ms project files) which the project managers change independently.
I do have:
- 1x master file
(containing project management functions and references to other MS project files which can be opened by expanding them in the master file)
- 6x sub schedules
The macro is part of the master file.
The problem:
'does return only the tasks of the master file
Set taskList = ActiveProject.Task
Does somebody have an idea how I can read the tasks of the referenced files as well? Do I have to manually open them? If yes, how can I do that and can I get all tasks in one list to be able to go through them with a for loop?
Many thanks in advance!
Lep