VBA reporting on time phased data / projects sharing a common resource file

[Robert M. Darby]

Hi all,
In the past, I’ve used a VB script to dump the task data for individual projects into a Excel pivot table for the resource managers. Now, I’m working 13 projects and decided to use a shared resource file — a first for me. Does anyone have experience doing something similar? Anything I need to consider? As I walk through the projects’ tasks, do I need to exclude the Master Schedule and the shared resource file? Just starting to look at this now….

Thanks,
Mark

[Robert M. Darby]

All,
I’ve worked through this and found that walking through the time phased data with VB will not work if your project shares resources. I don’t understand why, though. My workaround: save a copy of the file to another directory. Open the copy but decline to open the shared resources file. Then, once open, change the resources to use those that are local. A little time consuming… but if you’re creating a report spanning more than a project or two, you’ll still save time.

Mark

[Author]

Posts