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….
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.