AutoRecover Property

Returns an AutoRecover object, which backs up all file formats on a timed interval.

expression   Required. An expression that returns one of the objects in the Applies To list.

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