View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jerry Eco Jerry Eco is offline
external usenet poster
 
Posts: 1
Default ActiveWorkbook.Save saves to wrong directory

ActiveWorkbook.Save creates a new spreadsheet in Documents instead of saving
the spreadsheet in its current location. I am using Excel 2007 with a 2003
file (.xls).

The macro is in personal.xlsb and is used to make a few minor fixes to the
active spreadsheet. I want to save the active spreadsheet before I make
those fixes, in case something goes wrong. But, it needs to save it in
place, not create a new file somewhere else.

Thank you.
Jerry