Application.Run

[kclong]

I have a macro that runs other macros contained in the same file. File name is ClientSupport.xlsm, and the macro is GetReports. The code is:

Application.Run "ClientSupport.xlsm!GetReports"

This works fine. My problem is that I want to change the file name at times, but I don't want to have to update the macro each time. Since the GetReports macro is contained in the same file is there some way I can tell that macro to run without having to specify the file name?

Any other thoughts?

Thanks.

 

[VoG]

Try

Application.Run "GetReports"

 

[pcc]

or even

GetReports

 

[kclong]

Thank you. Very simple. It works. I should have thought of that first.