Application.AutoRecover Property (Excel)
Returns an AutoRecover object, which backs up all file formats on a timed interval.
Syntax
expression .AutoRecover
expression A variable that represents an Application object.
Remarks
Valid time intervals are whole numbers from 1 to 120.
Example
In this example, the Time property is used in conjunction with the AutoRecover property to set the time interval for Microsoft Excel to wait before saving another copy to five minutes.
Sub UseAutoRecover()
Application.AutoRecover.Time = 5
MsgBox "The time that will elapse between each automatic " & _
"save has been set to " & _
Application.AutoRecover.Time & " minutes."
End Sub