Loading...
Quick Links

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

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #412835 Reply

    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

    #412896 Reply

    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

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: VBA reporting on time phased data / projects sharing a common resource file
Your information: