Class AutoRecover (Excel VBA)
The class AutoRecover represents the automatic recovery features of a workbook.
Enabled
True if the object is enabled.
Parent
Returns the parent object for the specified object. Read-only.
Path
Returns or sets a String value that represents the complete path to where Microsoft Excel will store the AutoRecover temporary files.
Sub SetPath()
Application.AutoRecover.Path = "C:\"
End Sub
Time
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.
Sub SetTimeValue()
Application.AutoRecover.Time = 5
MsgBox "The AutoRecover time interval is set at " & _
Application.AutoRecover.Time & " minutes."
End Sub