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
Bookmarks