Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Application.AutoRecover Property

Office 2007
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.

Visual Basic for Applications
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



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.