Changing AutoSave location programmatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We had a server crash. We replaced it with a new box. The old Autosave
location was:

\\<server name>\path.

Excel now can not find that location. When I go to Tool -> Options, and
click on any of the tabs, I get the error message, "Cannot access directory
"\\<server name>\path".

Is there a way I can turn off AutoSave or change the AutoSave path through
VBA?
 
A couple of clarifications:
I am using 2003, and am talking about the AutoRecovery feature (not
AutoSave). I would gladly give up AutoRecovery to regain access to my
Tools->Options dialogue box. :(
 
Solution:

Private Sub AutoRecoverPath()
Application.AutoRecover.Enabled = True
Application.AutoRecover.Path = "C:\"
End Sub

Interestingly, setting the path to "Z:\Marcotte\AutoSave" gave me a Run Time
Error 1004.
 
Back
Top