Referring to a FileName in Macro

[DoctorV]

I have a Macro with the following code

Application.Run "TestQry!Macro2"
Application.Run "TestQry!Macro1"

TestQry is the name of the file. Is there anyway that this macro cod
can refer to the activeWorkbook or filename so that if the file i
saved to a new name this macro will still ru

 

[Dave Peterson]

How about just:

macro2
or even
call macro2

I have a Macro with the following code

Application.Run "TestQry!Macro2"
Application.Run "TestQry!Macro1"

TestQry is the name of the file. Is there anyway that this macro code
can refer to the activeWorkbook or filename so that if the file is
saved to a new name this macro will still run