Name

AutoRecover Object

Synopsis

Path: Application - AutoRecover

Object

Properties

AutoRecover

  • Enabled( ) As Boolean

  • Path( ) As String

  • Time( ) As Long

The AutoRecover feature allows for the possible recovery of data if Excel XP stops responding (or should I say when Excel XP stops responding?). The user can set the location in which Excel will save AutoRecover files as well as the time between saving.

The AutoRecover object implements automatic recovery. Its Path property sets the location where Excel will place the AutoRecover file and its Time property sets the time (in minutes) interval for backing up the workbook to the AutoRecover file, as in: 

Application.AutoRecover.Path = "d:\temp"
Application.AutoRecover.Time = 10' minutes

Get Writing Excel Macros with VBA, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial