Class AutoRecover (Excel VBA)

The class AutoRecover represents the automatic recovery features of a workbook.


To use a AutoRecover class variable it first needs to be instantiated, for example

Dim arr as AutoRecover
Set arr = Application.AutoRecover

AutoRecover class variables can be set using the Application.AutoRecover procedure.


True if the object is enabled.

Application.AutoRecover.Enabled = True


Returns or sets a String value that represents the complete path to where Microsoft Excel will store the AutoRecover temporary files.

Application.AutoRecover.Path =


Sets or returns the time interval for the AutoRecover object. Permissible values are integers from 1 to 120 minutes. The default value is 10 minutes.

Entering a decimal value will round to the nearest whole number. For example, entering a value of 5.5 is the equivalent of 6. If time values outside the valid range are entered, Microsoft Excel will revert to the previous time value used.

Application.AutoRecover.Time = 5