AutoRecover Object

  • Article

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.

Application
Aa612941.parchild(en-us,office.10).gifAutoRecover

Represents the automatic recovery features of a workbook. Properties for the AutoRecover object determine the path and time interval for backing up all files.

Using the AutoRecover object

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. The following example sets the path of the AutoRecover file to drive C.

  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.

Note   Units for the Time property are in minutes.

  Sub SetTime()

    Application.AutoRecover.Time = 5

End Sub