Hi, so my problem is that I have a file that will serve as a master document called TwoWeekLookAhead.xlsm that I need to be able to rename and have the macros all reference the new document. To do this I can just manually find and replace all the VBA references to TwoWeekLookAhead.xlsm with "NewFileName.xlsm", but I would like to do this through a macro so that my coworkers can do it without knowing anything about VBA/Macros. Does anyone have any idea of how I could do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro for Finding/Replacing within another Macro
- Thread starter tjc2273
- Start date
Similar threads
- Question
