Excel File Objects

Workbook (1995) Represents a Microsoft Excel workbook. The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.

AcceptAllChanges([When], [Who], [Where])
AcceptLabelsInFormulas [= setting]
Activate()
ActiveChart
ActiveSheet
AddinInstall
AddinUninstall
AddToFavorites()
AfterXmlExport
AfterXmlImport
Application
Author [= setting]
AutoUpdateFrequency [= setting]
AutoUpdateSaveChanges [= setting]
BeforeClose
BeforePrint
BeforeSave
BeforeXmlExport
BeforeXmlImport
BreakLink(Name, Type)
BuiltinDocumentProperties
CalculationVersion
CanCheckIn()
ChangeFileAccess(Mode, [WritePassword], [Notify])
ChangeHistoryDuration [= setting]
ChangeLink(Name, NewName, [Type])
Charts
CheckIn([SaveChanges], [Comments], [MakePublic])
Close([SaveChanges], [Filename], [RouteWorkbook])
CodeName
Colors [= setting]
CommandBars
Comments [= setting]
ConflictResolution [= setting]
Container
CreateBackup
CreateObjRef(requestedType)
Creator
CustomDocumentProperties
CustomViews
Date1904 [= setting]
Deactivate
DeleteNumberFormat(NumberFormat)
DialogSheets
DisplayDrawingObjects [= setting]
DisplayInkComments [= setting]
DocumentLibraryVersions
Dummy16()
Dummy17(calcid)
EnableAutoRecover [= setting]
EndReview()
EnvelopeVisible [= setting]
Equals(obj)
Excel4IntlMacroSheets
Excel4MacroSheets
ExclusiveAccess()
FileFormat
FollowHyperlink(Address, [SubAddress], [NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo])
ForwardMailer()
FullName
FullNameURLEncoded
GetHashCode()
GetLifetimeService()
GetType()
HasMailer [= setting]
HasPassword
HasRoutingSlip [= setting]
HighlightChangesOnScreen [= setting]
HighlightChangesOptions([When], [Who], [Where])
HTMLProject
InactiveListBorderVisible [= setting]
InitializeLifetimeService()
IsAddin [= setting]
IsInplace
KeepChangeHistory [= setting]
Keywords [= setting]
LinkInfo(Name, LinkInfo, [Type], [EditionRef])
LinkSources([Type])
ListChangesOnNewSheet [= setting]
Mailer
MergeWorkbook(Filename)
Modules
MultiUserEditing
Name
Names
NewSheet
NewWindow()
OnSave [= setting]
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
Open
OpenLinks(Name, [ReadOnly], [Type])
Parent
Password [= setting]
PasswordEncryptionAlgorithm
PasswordEncryptionFileProperties
PasswordEncryptionKeyLength
PasswordEncryptionProvider
Path
Permission
PersonalViewListSettings [= setting]
PersonalViewPrintSettings [= setting]
PivotCaches()
PivotTableCloseConnection
PivotTableOpenConnection
PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
Post([DestName])
PrecisionAsDisplayed [= setting]
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Protect([Password], [Structure], [Windows])
ProtectSharing([Filename], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [SharingPassword])
ProtectStructure
ProtectWindows
PublishObjects
PurgeChangeHistoryNow(Days, [SharingPassword])
ReadOnly
ReadOnlyRecommended [= setting]
RecheckSmartTags()
RefreshAll()
RejectAllChanges([When], [Who], [Where])
ReloadAs(Encoding)
RemovePersonalInformation [= setting]
RemoveUser(Index)
Reply()
ReplyAll()
ReplyWithChanges([ShowMessage])
ResetColors()
RevisionNumber
Route()
Routed
RoutingSlip
RunAutoMacros(Which)
Save()
SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
SaveAsXMLData(Filename, Map)
SaveCopyAs([Filename])
Saved [= setting]
SaveLinkValues [= setting]
sblt(s)
SendFaxOverInternet([Recipients], [Subject], [ShowMessage])
SendForReview([Recipients], [Subject], [ShowMessage], [IncludeAttachment])
SendMail(Recipients, [Subject], [ReturnReceipt])
SendMailer([FileFormat], [Priority])
SetLinkOnData(Name, [Procedure])
SetPasswordEncryptionOptions([PasswordEncryptionProvider], [PasswordEncryptionAlgorithm], [PasswordEncryptionKeyLength], [PasswordEncryptionFileProperties])
SharedWorkspace
SheetActivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
SheetPivotTableUpdate
Sheets
SheetSelectionChange
ShowConflictHistory [= setting]
ShowPivotTableFieldList [= setting]
SmartDocument
SmartTagOptions
Styles
Subject [= setting]
Sync
TemplateRemoveExtData [= setting]
Title [= setting]
ToggleFormsDesign()
ToString()
Unprotect([Password])
UnprotectSharing([SharingPassword])
UpdateFromFile()
UpdateLink([Name], [Type])
UpdateLinks [= setting]
UpdateRemoteReferences [= setting]
UserControl [= setting]
UserStatus
VBASigned
VBProject
WebOptions
WebPagePreview()
WindowActivate
WindowDeactivate
WindowResize
Windows
WorkbookEvents_Event_Activate
WorkbookEvents_Event_Sync
Worksheets
WritePassword [= setting]
WriteReserved
WriteReservedBy
XmlImport(Url, ImportMap, [Overwrite], [Destination])
XmlImportXml(Data, ImportMap, [Overwrite], [Destination])
XmlMaps
XmlNamespaces

WorkbookEvents (1997) Hidden or unsupported element.

Activate()
AddinInstall()
AddinUninstall()
AfterXmlExport(Map, Url, Result)
AfterXmlImport(Map, IsRefresh, Result)
BeforeClose(Cancel)
BeforePrint(Cancel)
BeforeSave(SaveAsUI, Cancel)
BeforeXmlExport(Map, Url, Cancel)
BeforeXmlImport(Map, Url, IsRefresh, Cancel)
Deactivate()
NewSheet(Sh)
Open()
PivotTableCloseConnection(Target)
PivotTableOpenConnection(Target)
SheetActivate(Sh)
SheetBeforeDoubleClick(Sh, Target, Cancel)
SheetBeforeRightClick(Sh, Target, Cancel)
SheetCalculate(Sh)
SheetChange(Sh, Target)
SheetDeactivate(Sh)
SheetFollowHyperlink(Sh, Target)
SheetPivotTableUpdate(Sh, Target)
SheetSelectionChange(Sh, Target)
Sync(SyncEventType)
WindowActivate(Wn)