update filename in macro

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.
 
B

Bob Phillips

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)
 
F

Frank Kabel

Hi
why hardcode the filename in your macro. you may use
activeworkbook.name
to get this name?
 
Top