Macros in saved workbook

  • 11 years ago
    I have recorded a macro in a workbook which runs fine, but when I save the workbook in a different name I get a debug message? The macro has a pivot table in it which is where the debug looks for the workbook name, is their any commands or ways to sort this problem

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.” - Tom Cargill