Export (0) Print
Expand All

Workbook Methods

The Workbook type exposes the following members.

  Name Description
Public method _PrintOut Reserved for internal use. (Inherited from _Workbook.)
Public method _Protect Reserved for internal use. (Inherited from _Workbook.)
Public method _SaveAs Reserved for internal use. (Inherited from _Workbook.)
Public method AcceptAllChanges Accepts all changes in the specified shared workbook. (Inherited from _Workbook.)
Public method Activate Activates the first window associated with the workbook. This won't run any Auto_Activate or Auto_Deactivate macros that might be attached to the workbook (use the RunAutoMacros method to run those macros). (Inherited from _Workbook.)
Public method add_Activate (Inherited from WorkbookEvents_Event.)
Public method add_AddinInstall (Inherited from WorkbookEvents_Event.)
Public method add_AddinUninstall (Inherited from WorkbookEvents_Event.)
Public method add_AfterSave (Inherited from WorkbookEvents_Event.)
Public method add_AfterXmlExport (Inherited from WorkbookEvents_Event.)
Public method add_AfterXmlImport (Inherited from WorkbookEvents_Event.)
Public method add_BeforeClose (Inherited from WorkbookEvents_Event.)
Public method add_BeforePrint (Inherited from WorkbookEvents_Event.)
Public method add_BeforeSave (Inherited from WorkbookEvents_Event.)
Public method add_BeforeXmlExport (Inherited from WorkbookEvents_Event.)
Public method add_BeforeXmlImport (Inherited from WorkbookEvents_Event.)
Public method add_Deactivate (Inherited from WorkbookEvents_Event.)
Public method add_NewChart (Inherited from WorkbookEvents_Event.)
Public method add_NewSheet (Inherited from WorkbookEvents_Event.)
Public method add_Open (Inherited from WorkbookEvents_Event.)
Public method add_PivotTableCloseConnection (Inherited from WorkbookEvents_Event.)
Public method add_PivotTableOpenConnection (Inherited from WorkbookEvents_Event.)
Public method add_RowsetComplete (Inherited from WorkbookEvents_Event.)
Public method add_SheetActivate (Inherited from WorkbookEvents_Event.)
Public method add_SheetBeforeDoubleClick (Inherited from WorkbookEvents_Event.)
Public method add_SheetBeforeRightClick (Inherited from WorkbookEvents_Event.)
Public method add_SheetCalculate (Inherited from WorkbookEvents_Event.)
Public method add_SheetChange (Inherited from WorkbookEvents_Event.)
Public method add_SheetDeactivate (Inherited from WorkbookEvents_Event.)
Public method add_SheetFollowHyperlink (Inherited from WorkbookEvents_Event.)
Public method add_SheetPivotTableAfterValueChange (Inherited from WorkbookEvents_Event.)
Public method add_SheetPivotTableBeforeAllocateChanges (Inherited from WorkbookEvents_Event.)
Public method add_SheetPivotTableBeforeCommitChanges (Inherited from WorkbookEvents_Event.)
Public method add_SheetPivotTableBeforeDiscardChanges (Inherited from WorkbookEvents_Event.)
Public method add_SheetPivotTableChangeSync (Inherited from WorkbookEvents_Event.)
Public method add_SheetPivotTableUpdate (Inherited from WorkbookEvents_Event.)
Public method add_SheetSelectionChange (Inherited from WorkbookEvents_Event.)
Public method add_Sync (Inherited from WorkbookEvents_Event.)
Public method add_WindowActivate (Inherited from WorkbookEvents_Event.)
Public method add_WindowDeactivate (Inherited from WorkbookEvents_Event.)
Public method add_WindowResize (Inherited from WorkbookEvents_Event.)
Public method AddToFavorites Adds a shortcut to the workbook or a hyperlink to the Favorites folder. (Inherited from _Workbook.)
Public method ApplyTheme Applies the specified theme to the current workbook. (Inherited from _Workbook.)
Public method BreakLink Converts formulas linked to other Microsoft Excel sources or OLE sources to values. (Inherited from _Workbook.)
Public method CanCheckIn True if Microsoft Excel can check in a specified workbook to a server. (Inherited from _Workbook.)
Public method ChangeFileAccess Changes the access permissions for the workbook. This may require an updated version to be loaded from the disk. (Inherited from _Workbook.)
Public method ChangeLink Changes a link from one document to another. (Inherited from _Workbook.)
Public method CheckIn Returns a workbook from a local computer to a server and sets the local workbook to read-only so that it cannot be edited locally. Calling this method will also close the workbook. (Inherited from _Workbook.)
Public method CheckInWithVersion Saves a workbook to a server from a local computer, and sets the local workbook to read-only so that it cannot be edited locally. (Inherited from _Workbook.)
Public method Close Closes the object. (Inherited from _Workbook.)
Public method DeleteNumberFormat Deletes a custom number format from the workbook. (Inherited from _Workbook.)
Public method DisableDraftModeAllCharts Reserved for internal use. (Inherited from _Workbook.)
Public method Dummy16 Reserved for internal use. (Inherited from _Workbook.)
Public method Dummy17 Reserved for internal use. (Inherited from _Workbook.)
Public method EnableConnections The EnableConnections() method allows developers to programmatically enable data connections within the workbook for the user. (Inherited from _Workbook.)
Public method EnableDraftModeAllCharts Reserved for internal use. (Inherited from _Workbook.)
Public method EndReview Terminates a review of a file that has been sent for review using the SendForReview method. (Inherited from _Workbook.)
Public method ExclusiveAccess Assigns the current user exclusive access to the workbook that's open as a shared list. (Inherited from _Workbook.)
Public method ExportAsFixedFormat The ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object) method is used to publish a workbook to either the PDF or XPS format. (Inherited from _Workbook.)
Public method FollowHyperlink Displays a cached document if it’s already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application. (Inherited from _Workbook.)
Public method ForwardMailer You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. (Inherited from _Workbook.)
Public method GetWorkflowTasks Returns the collection of WorkflowTask objects for the specified workbook. (Inherited from _Workbook.)
Public method GetWorkflowTemplates Returns the collection of WorkflowTemplate objects for the specified workbook. (Inherited from _Workbook.)
Public method HighlightChangesOptions Controls how changes are shown in a shared workbook. (Inherited from _Workbook.)
Public method LinkInfo Returns the link date and update status. Object. (Inherited from _Workbook.)
Public method LinkSources Returns an array of links in the workbook. The names in the array are the names of the linked documents, editions, or DDE or OLE servers. Returns Empty if there are no links. Object. (Inherited from _Workbook.)
Public method LockServerFile Locks the workbook on the server to prevent modification. (Inherited from _Workbook.)
Public method MergeWorkbook Merges changes from one workbook into an open workbook. (Inherited from _Workbook.)
Public method NewWindow Creates a new window or a copy of the specified window. (Inherited from _Workbook.)
Public method OpenLinks Opens the supporting documents for a link or links. (Inherited from _Workbook.)
Public method PivotCaches Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only. (Inherited from _Workbook.)
Public method PivotTableWizard Reserved for internal use. (Inherited from _Workbook.)
Public method Post Posts the specified workbook to a public folder. This method works only with a Microsoft Exchange client connected to a Microsoft Exchange server. (Inherited from _Workbook.)
Public method PrintOut Prints the object. (Inherited from _Workbook.)
Public method PrintOutEx Reserved for internal use. (Inherited from _Workbook.)
Public method PrintPreview Shows a preview of the object as it would look when printed. (Inherited from _Workbook.)
Public method Protect Protects a workbook so that it cannot be modified. (Inherited from _Workbook.)
Public method ProtectSharing Saves the workbook and protects it for sharing. (Inherited from _Workbook.)
Public method ProtectSharingEx Reserved for internal use. (Inherited from _Workbook.)
Public method PurgeChangeHistoryNow Removes entries from the change log for the specified workbook. (Inherited from _Workbook.)
Public method RecheckSmartTags Causes a foreground smart tag check to occur, automatically annotating data that was not annotated before. (Inherited from _Workbook.)
Public method RefreshAll Refreshes all external data ranges and PivotTable reports in the specified workbook. (Inherited from _Workbook.)
Public method RejectAllChanges Rejects all changes in the specified shared workbook. (Inherited from _Workbook.)
Public method ReloadAs Reloads a workbook based on an HTML document, using the specified document encoding. (Inherited from _Workbook.)
Public method remove_Activate (Inherited from WorkbookEvents_Event.)
Public method remove_AddinInstall (Inherited from WorkbookEvents_Event.)
Public method remove_AddinUninstall (Inherited from WorkbookEvents_Event.)
Public method remove_AfterSave (Inherited from WorkbookEvents_Event.)
Public method remove_AfterXmlExport (Inherited from WorkbookEvents_Event.)
Public method remove_AfterXmlImport (Inherited from WorkbookEvents_Event.)
Public method remove_BeforeClose (Inherited from WorkbookEvents_Event.)
Public method remove_BeforePrint (Inherited from WorkbookEvents_Event.)
Public method remove_BeforeSave (Inherited from WorkbookEvents_Event.)
Public method remove_BeforeXmlExport (Inherited from WorkbookEvents_Event.)
Public method remove_BeforeXmlImport (Inherited from WorkbookEvents_Event.)
Public method remove_Deactivate (Inherited from WorkbookEvents_Event.)
Public method remove_NewChart (Inherited from WorkbookEvents_Event.)
Public method remove_NewSheet (Inherited from WorkbookEvents_Event.)
Public method remove_Open (Inherited from WorkbookEvents_Event.)
Public method remove_PivotTableCloseConnection (Inherited from WorkbookEvents_Event.)
Public method remove_PivotTableOpenConnection (Inherited from WorkbookEvents_Event.)
Public method remove_RowsetComplete (Inherited from WorkbookEvents_Event.)
Public method remove_SheetActivate (Inherited from WorkbookEvents_Event.)
Public method remove_SheetBeforeDoubleClick (Inherited from WorkbookEvents_Event.)
Public method remove_SheetBeforeRightClick (Inherited from WorkbookEvents_Event.)
Public method remove_SheetCalculate (Inherited from WorkbookEvents_Event.)
Public method remove_SheetChange (Inherited from WorkbookEvents_Event.)
Public method remove_SheetDeactivate (Inherited from WorkbookEvents_Event.)
Public method remove_SheetFollowHyperlink (Inherited from WorkbookEvents_Event.)
Public method remove_SheetPivotTableAfterValueChange (Inherited from WorkbookEvents_Event.)
Public method remove_SheetPivotTableBeforeAllocateChanges (Inherited from WorkbookEvents_Event.)
Public method remove_SheetPivotTableBeforeCommitChanges (Inherited from WorkbookEvents_Event.)
Public method remove_SheetPivotTableBeforeDiscardChanges (Inherited from WorkbookEvents_Event.)
Public method remove_SheetPivotTableChangeSync (Inherited from WorkbookEvents_Event.)
Public method remove_SheetPivotTableUpdate (Inherited from WorkbookEvents_Event.)
Public method remove_SheetSelectionChange (Inherited from WorkbookEvents_Event.)
Public method remove_Sync (Inherited from WorkbookEvents_Event.)
Public method remove_WindowActivate (Inherited from WorkbookEvents_Event.)
Public method remove_WindowDeactivate (Inherited from WorkbookEvents_Event.)
Public method remove_WindowResize (Inherited from WorkbookEvents_Event.)
Public method RemoveDocumentInformation Removes all information of the specified type from the workbook. (Inherited from _Workbook.)
Public method RemoveUser Disconnects the specified user from the shared workbook. (Inherited from _Workbook.)
Public method Reply You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. (Inherited from _Workbook.)
Public method ReplyAll You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. (Inherited from _Workbook.)
Public method ReplyWithChanges Sends an e-mail message to the author of a workbook that has been sent out for review, notifying them that a reviewer has completed review of the workbook. (Inherited from _Workbook.)
Public method ResetColors Resets the color palette to the default colors. (Inherited from _Workbook.)
Public method Route Routes the workbook, using the workbook's current routing slip. (Inherited from _Workbook.)
Public method RunAutoMacros Runs the Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro attached to the workbook. This method is included for backward compatibility. You should use the Open, Close, Activate and Deactivate events instead of these macros. (Inherited from _Workbook.)
Public method Save Saves changes to the specified workbook. (Inherited from _Workbook.)
Public method SaveAs Saves changes to the workbook in a different file. (Inherited from _Workbook.)
Public method SaveAsXMLData Exports the data that has been mapped to the specified XML schema map to an XML data file. (Inherited from _Workbook.)
Public method SaveCopyAs Saves a copy of the workbook to a file but doesn't modify the open workbook in memory. (Inherited from _Workbook.)
Public method sblt Reserved for internal use. (Inherited from _Workbook.)
Public method SendFaxOverInternet Sends a worksheet as a fax to the specified recipients. (Inherited from _Workbook.)
Public method SendForReview Sends a workbook in an e-mail message for review to the specified recipients. (Inherited from _Workbook.)
Public method SendMail Sends the workbook by using the installed mail system. (Inherited from _Workbook.)
Public method SendMailer You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. (Inherited from _Workbook.)
Public method SetLinkOnData Sets the name of a procedure that runs whenever a DDE link is updated. (Inherited from _Workbook.)
Public method SetPasswordEncryptionOptions Sets the options for encrypting workbooks using passwords. (Inherited from _Workbook.)
Public method ToggleFormsDesign Toggles form design mode on or off. (Inherited from _Workbook.)
Public method Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected. (Inherited from _Workbook.)
Public method UnprotectSharing Turns off protection for sharing and saves the workbook. (Inherited from _Workbook.)
Public method UpdateFromFile Updates a read-only workbook from the saved disk version of the workbook if the disk version is more recent than the copy of the workbook that is loaded in memory. If the disk copy hasn't changed since the workbook was loaded, the in-memory copy of the workbook isn't reloaded. (Inherited from _Workbook.)
Public method UpdateLink Updates a Microsoft Excel, DDE, or OLE link (or links). (Inherited from _Workbook.)
Public method WebPagePreview Displays a preview of the specified workbook as it would look if saved as a Web page. (Inherited from _Workbook.)
Public method XmlImport Imports an XML data file into the current workbook. Returns XlXmlImportResult. (Inherited from _Workbook.)
Public method XmlImportXml Imports an XML data stream that has been previously loaded into memory. Returns XlXmlImportResult. (Inherited from _Workbook.)
Top
Show:
© 2015 Microsoft