Hi All,
So I have some code in Access that creates an excel spreadsheet via a table in excel and then is running a macro from a static file. All the information populates but when the Macro is called, I keep erroring out with 1004: "Cannot run the macro "FilePath!PivotName'. The Macro may not be available in this workbook or all macros may be disabled."

Im stumped because made macros accessible and have the workbook that contains the macro open. Please help me out here. Here is the full code. I will highlight the trouble / debug error

Please Login or Register  to view this content.