View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Saving a file via a Macro?

Not the clearest question, Mr. B. How about ActiveWorkbook.Save?

--
Jim Rech
Excel MVP
"Mr B" wrote in message
...
| I'm sure this is easy but what's the syntax to have a sheet save itself
while running a macro? Not a Save As a different name, just to save the
file so things don't get lost.
|
| Thanks.