AutoRecover Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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

expression.AutoRecover

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