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

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

Viewing 1 reply thread
  • Author
    Posts
    • #412835

      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

      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 1 reply thread
  • You must be logged in to reply to this topic.