Export (0) Print
Expand All

AutoRecover Object

Office 2007
Represents the automatic recovery features of a workbook.

Remarks

Properties for the AutoRecover object determine the path and time interval for backing up all files.

Use the AutoRecover property of the Application object to return an AutoRecover object.

Use the Path property of the AutoRecover object to set the path for where the AutoRecover file will be saved.

Example
The following example sets the path of the AutoRecover file to drive C.

Visual Basic for Applications
Sub SetPath()

    Application.AutoRecover.Path = "C:\"

End Sub

Use the Time property of the AutoRecover object to set the time interval for backing up all files.

Bb210087.vs_note(en-us,office.12).gif  Note
Units for the Time property are in minutes.
Visual Basic for Applications
Sub SetTime()

    Application.AutoRecover.Time = 5

End Sub



Community Additions

ADD
Show:
© 2014 Microsoft