Changing AutoSave location programmatically

M

Marcotte A

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?
 
M

Marcotte A

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. :(
 
M

Marcotte A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top