update filename in macro

  • Thread starter Thread starter matmich
  • Start date Start date
M

matmich

how would I have the filename updated automatically in my programs "run
all macros". Users want me to change the filename everytime an update
is made, but when I do and they use it, it needs to be debugged -- the
problem the filename in the macro isn't the same as the actual file
that is running. Its a date that I put into the filename that the user
needs.
 
In your macro, use Activeworkbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
why hardcode the filename in your macro. you may use
activeworkbook.name
to get this name?
 
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

macro to print xps then save with name value in (B2) 8
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
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
Need help in VBA for embedded object in excel 1
Excell 2000 macro will not open file! 1
Change Filename in Macro 3
Using filename retrieved from GetOpenFilename 1
macro reference changes with filename 1

Back
Top