Changing File Location For Excel Document

[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

 

[Dave Peterson]

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.

 

[Don Guillett]

try this

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

 

[Greg Matthews]

Hi,

Thanks for this, found this and amended this to my choice location.

Greg.