Get the correct Excel Workbook name while running macro in project RRS feed

  • Question

  • I am trying to run a macro out of MS Project that creates a data file and then a Pivot Table.  The program works fine the first time I run it however if I run it again it will reference the original workbook that was created and errors out.  I can't figure out a way to get it to reference the new workbook created and ignore any previous workbooks without closing project and running the program again.

    Is there a specific method for working with Excel workbooks when you are in another application in order to avoid this scenario?

    Sunday, October 27, 2013 2:55 AM

All replies