Referring to a FileName in Macro

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

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
 
How about just:

macro2
or even
call macro2


DoctorV < said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop Command Question 4
Preventing prompts from appearing with DoCmd 3
DoCmd OutputTo Error 5
Need help in VBA for embedded object in excel 1
Save Macro enabled WB as w/o macro 13
3065-Cannot execute select query--why not? 4
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
word 2007 macro 4

Back
Top