Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2007
Excel 2007
Excel 2007 Developer Reference
Excel Object Model Reference
Workbook Object
Properties
ActiveChart Property
ActiveSheet Property
Application Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
BuiltinDocumentProperties Property
CalculationVersion Property
ChangeHistoryDuration Property
Charts Property
CheckCompatibility Property
CodeName Property
Colors Property
CommandBars Property
ConflictResolution Property
Connections Property
ConnectionsDisabled Property
Container Property
ContentTypeProperties Property
CreateBackup Property
Creator Property
CustomDocumentProperties Property
CustomViews Property
CustomXMLParts Property
Date1904 Property
DefaultPivotTableStyle Property
DefaultTableStyle Property
DisplayDrawingObjects Property
DisplayInkComments Property
DocumentInspectors Property
DocumentLibraryVersions Property
DoNotPromptForConvert Property
EnableAutoRecover Property
EncryptionProvider Property
EnvelopeVisible Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
Excel8CompatibilityMode Property
FileFormat Property
Final Property
ForceFullCalculation Property
FullName Property
FullNameURLEncoded Property
HasPassword Property
HasRoutingSlip Property
HasVBProject Property
HighlightChangesOnScreen Property
IconSets Property
InactiveListBorderVisible Property
IsAddin Property
IsInplace Property
KeepChangeHistory Property
ListChangesOnNewSheet Property
Mailer Property
MultiUserEditing Property
Name Property
Names Property
Parent Property
Password Property
PasswordEncryptionAlgorithm Property
PasswordEncryptionFileProperties Property
PasswordEncryptionKeyLength Property
PasswordEncryptionProvider Property
Path Property
Permission Property
PersonalViewListSettings Property
PersonalViewPrintSettings Property
PrecisionAsDisplayed Property
ProtectStructure Property
ProtectWindows Property
PublishObjects Property
ReadOnly Property
ReadOnlyRecommended Property
RemovePersonalInformation Property
Research Property
RevisionNumber Property
Saved Property
Routed Property
SaveLinkValues Property
ServerPolicy Property
RoutingSlip Property
ServerViewableItems Property
SharedWorkspace Property
Sheets Property
ShowConflictHistory Property
ShowPivotChartActiveFields Property
ShowPivotTableFieldList Property
Signatures Property
SmartDocument Property
SmartTagOptions Property
Styles Property
Sync Property
TableStyles Property
TemplateRemoveExtData Property
Theme Property
UpdateLinks Property
UpdateRemoteReferences Property
UserStatus Property
VBASigned Property
VBProject Property
WebOptions Property
Windows Property
Worksheets Property
WritePassword Property
WriteReserved Property
WriteReservedBy Property
XmlMaps Property
XmlNamespaces Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Workbook.EnableAutoRecover Property

Office 2007
Saves changed files, of all formats, on a timed interval. Read/write Boolean.

Syntax

expression.EnableAutoRecover

expression   A variable that represents a Workbook object.

Remarks

If Microsoft Excel fails, the system fails, or if the system is improperly shut down (not allowing Excel to save the changed files), the backed up files are opened and the user has an opportunity to save changes that otherwise would have been lost. When the user restarts Excel, a document recovery window opens, giving the user an option to recover the files they were working on. Setting this property to True (default) enables this feature.

Example

The following example checks the setting of the AutoRecover feature and if not enabled, Excel enables it and then notifies the user.

Visual Basic for Applications
Sub UseAutoRecover()

    ' Check to see if the feature is enabled, if not, enable it.
    If ActiveWorkbook.EnableAutoRecover = False Then
        ActiveWorkbook.EnableAutoRecover = True
        MsgBox "The AutoRecover feature has been enabled."
    Else
        MsgBox "The AutoRecover feature is already enabled."
    End If

End Sub

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.