If the file name is "hard coded" in a macro, how do I create a macro within a file that can be used with a
different file name?
I had (still have) a problem with a macro that I created that references other macros on different sheets in a file that generates an error message each time I click or use this macro.
I was advised in another forum that the macro is hard coded and it generates an error if I file save the file with a different name. The only problem with this theory is that the single or individual macros that are used on one sheet does not seem to have a problem, only the macro that is references different macros on several sheets is the macro that I continue to have problems with.
Thanks for any assistance.
different file name?
I had (still have) a problem with a macro that I created that references other macros on different sheets in a file that generates an error message each time I click or use this macro.
I was advised in another forum that the macro is hard coded and it generates an error if I file save the file with a different name. The only problem with this theory is that the single or individual macros that are used on one sheet does not seem to have a problem, only the macro that is references different macros on several sheets is the macro that I continue to have problems with.
Thanks for any assistance.