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.

"Marcotte A" wrote:

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

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.

"Marcotte A" wrote:

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