Newbie- Filename referencing in macros
THANK YOU!
-----Original Message-----
Ellen;
Try this:
Sub SaveIt()
ActiveWorkbook.Save
End Sub
Regards,
Jim Kobzeff
"Ellen" wrote in
message
...
I edited an Excel File with macros, saved a copy of the
file with a new
filename, and then found the macros in the new file are
attempting to call
the procedures from the original file, and returning
the
error "file
specified cannot be found", or something to that
effect.
Am I omitting something when I am saving a file with a
new filename with
macros?
I can see all the macros in the new file when I check
for
them, but it's as
though I need to remap the commandbuttons to the macros
in the current file.
Thanks in advance, Ellen
.
|