Autorecover Location

ToonArmyBarmy · Oct 14th 2011

A few years ago I set a custom location for AutoRecover files in excel. Now, following a few role changes, the path no longer exists on the network. When I try to change the location or select an tab in 'Tools/Option' I get an error "Cannot access directory \\blah\blah\blah\Auto Recover Files"

Is there any way around this?

Tim

Craig Ottley · Oct 17th 2011

Re: Autorecover Location

You can normally set this in VBA.... Try something along the lines of the following, but make sure it's a valid path as excel will test the path.

Code

Option Explicit


Sub SetPath()
    
    With Application
        .AutoRecover.Path = "C:\Users\Craig\Downloads"
    End With


End Sub

Display More

HTH

C

ToonArmyBarmy · Oct 18th 2011

Re: Autorecover Location

Thanks Craig, worked perfectly. Will make a donation when I get paid!

Tim

Autorecover Location

Participate now!

Share