View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default Newbie- Filename referencing in macros

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