Changing File Location For Excel Document

  • Thread starter Thread starter Greg Matthews
  • Start date Start date
G

Greg Matthews

Hi,

Can someone let give me the way to change the default file location when
saving Excel documents. I have checked Tools, Options and the Online Help
but can't seem to find the answer.

Thanks

Greg Matthews
 
If you're creating a brand new workbook (after file|new), then excel will use
the folder that's specified in:

Tools|Options|general tab|default file location.

If you started with an existing workbook and did a File|SaveAs, it depends on
what version you're running.

In xl97 (and before, IIRC), it'll use this same default location.

In xl2k (and above--maybe xl2002 and above???), it uses the same folder as the
workbook that it was started from.
 
try this

Sub savetofolder()
ActiveWorkbook.SaveAs "c:\yourfilelocation\" & ActiveWorkbook.Name
End Sub
 
Back
Top