is it possible to have a macro call another macro? if so, are there any
considerations I need to make? E.g.- will the macro be called depending on
the file name it is saved under? If that is the case, can the VB line that
calls the macro automatically update the file name as the file name changes?

I have a macro saved to a file "March 21_05" If the file changes to "March
22_05" can the listing of a macro within that file change within the code for
the new macro?

application.run will call another macro, however if you are looking to
update the macro name you will be calling, you might want to consider
userinput, or keeping a seperate file somewhere with the current name of the
file you will be calling, unless you want to edit the VBA project it self and
change the actuall code but that is a bit more complicated.

"GJR3599" wrote:

is it possible to have a macro call another macro? if so, are there any
considerations I need to make? E.g.- will the macro be called depending on
the file name it is saved under? If that is the case, can the VB line that
calls the macro automatically update the file name as the file name changes?

I have a macro saved to a file "March 21_05" If the file changes to "March
22_05" can the listing of a macro within that file change within the code for
the new macro?