Renaming Spreadsheet causes macros to fail

**AdamParker** · 05-16-2008, 03:25 PM

Hello,
I have a quick and hopefully very easy question.

I have this code that runs several macros for me:

    Application.Run "'Working.xls'!Step2"
    Application.Run "'Working.xls'!Step3"
    Application.Run "'Working.xls'!Step4"

My question is can I take out the "working.xls" part and put something else in its place? This spreadsheet will be taken by many people and renamed, etc...

I noticed that when I rename the spreadsheet, the macro's fail because it can't find working.xls

Any suggestions/comments would be greatly appreciated.
Thanks,

Adam Parker

**Rick_Stanich** · 05-16-2008, 04:04 PM

The macro must belong to "Working.xls" workbook. I think once you "save as" the originating workbook is no longer open and the macro would no longer be available.

You could put the macros in a "personal.xls", place that on each computer and they will have access to the macro regardless of the active workbook name.

    Application.Run "'Personal.xls'!Step2"
    Application.Run "'Personal.xls'!Step3"
    Application.Run "'Personal.xls'!Step4"

**Phil_V** · 09-11-2008, 11:45 AM

Is this code contained within the same workbook as the macros it's calling, or is it in a different workbook?

Renaming Spreadsheet causes macros to fail

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Renaming Spreadsheet causes macros to fail

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions