Change macro on save
Posted by David w on April 02, 2001 6:06 AM
I have a template that auto opens a data workbook
when it is opened and then returns to the template.
The problem I have I after you save the file under a
different name the next time you open the file you get
a run time error.
Can we have a macro that rewrites on save to change the
name (job20011)to the current filename?
Or is there a better way to open a workbook without
making it activate?