_Workbook methods

The _Workbook type exposes the following members.

  Name Description
Public method _PrintOut Reserved for internal use.
Public method _Protect Reserved for internal use.
Public method _SaveAs Reserved for internal use.
Public method AcceptAllChanges Accepts all changes in the specified shared 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).
Public method AddToFavorites Adds a shortcut to the workbook or a hyperlink to the Favorites folder.
Public method ApplyTheme Applies the specified theme to the current workbook.
Public method BreakLink Converts formulas linked to other Microsoft Excel sources or OLE sources to values.
Public method CanCheckIn True if Microsoft Excel can check in a specified workbook to a server.
Public method ChangeFileAccess Changes the access permissions for the workbook. This may require an updated version to be loaded from the disk.
Public method ChangeLink Changes a link from one document to another.
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.
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.
Public method Close Closes the object.
Public method DeleteNumberFormat Deletes a custom number format from the workbook.
Public method Dummy16 Reserved for internal use.
Public method Dummy17 Reserved for internal use.
Public method Dummy26
Public method Dummy27
Public method EnableConnections The EnableConnections() method allows developers to programmatically enable data connections within the workbook for the user.
Public method EndReview Terminates a review of a file that has been sent for review using the SendForReview method.
Public method ExclusiveAccess Assigns the current user exclusive access to the workbook that's open as a shared list.
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.
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.
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.
Public method GetWorkflowTasks Returns the collection of WorkflowTask objects for the specified workbook.
Public method GetWorkflowTemplates Returns the collection of WorkflowTemplate objects for the specified workbook.
Public method HighlightChangesOptions Controls how changes are shown in a shared workbook.
Public method LinkInfo Returns the link date and update status. Object.
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.
Public method LockServerFile Locks the workbook on the server to prevent modification.
Public method MergeWorkbook Merges changes from one workbook into an open workbook.
Public method NewWindow Creates a new window or a copy of the specified window.
Public method OpenLinks Opens the supporting documents for a link or links.
Public method PivotCaches Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only.
Public method PivotTableWizard Reserved for internal use.
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.
Public method PrintOut Prints the object.
Public method PrintOutEx Reserved for internal use.
Public method PrintPreview Shows a preview of the object as it would look when printed.
Public method Protect Protects a workbook so that it cannot be modified.
Public method ProtectSharing Saves the workbook and protects it for sharing.
Public method ProtectSharingEx Reserved for internal use.
Public method PurgeChangeHistoryNow Removes entries from the change log for the specified workbook.
Public method RecheckSmartTags Causes a foreground smart tag check to occur, automatically annotating data that was not annotated before.
Public method RefreshAll Refreshes all external data ranges and PivotTable reports in the specified workbook.
Public method RejectAllChanges Rejects all changes in the specified shared workbook.
Public method ReloadAs Reloads a workbook based on an HTML document, using the specified document encoding.
Public method RemoveDocumentInformation Removes all information of the specified type from the workbook.
Public method RemoveUser Disconnects the specified user from the shared 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.
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.
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.
Public method ResetColors Resets the color palette to the default colors.
Public method Route Routes the workbook, using the workbook's current routing slip.
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.
Public method Save Saves changes to the specified workbook.
Public method SaveAs Saves changes to the workbook in a different file.
Public method SaveAsXMLData Exports the data that has been mapped to the specified XML schema map to an XML data file.
Public method SaveCopyAs Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.
Public method sblt Reserved for internal use.
Public method SendFaxOverInternet Sends a worksheet as a fax to the specified recipients.
Public method SendForReview Sends a workbook in an e-mail message for review to the specified recipients.
Public method SendMail Sends the workbook by using the installed mail system.
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.
Public method SetLinkOnData Sets the name of a procedure that runs whenever a DDE link is updated.
Public method SetPasswordEncryptionOptions Sets the options for encrypting workbooks using passwords.
Public method ToggleFormsDesign Toggles form design mode on or off.
Public method Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
Public method UnprotectSharing Turns off protection for sharing and saves the 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.
Public method UpdateLink Updates a Microsoft Excel, DDE, or OLE link (or links).
Public method WebPagePreview Displays a preview of the specified workbook as it would look if saved as a Web page.
Public method XmlImport Imports an XML data file into the current workbook. Returns XlXmlImportResult.
Public method XmlImportXml Imports an XML data stream that has been previously loaded into memory. Returns XlXmlImportResult.
Top
Show: