The Workbook type exposes the following members.

Methods

---

	Name	Description
	_PrintOut	Infrastructure.
	_Protect	Infrastructure.
	_SaveAs	Infrastructure.
	AcceptAllChanges	Accepts all changes in the shared workbook.
	Activate	Activates the first window associated with the workbook.
	AddToFavorites	Adds a shortcut to the workbook to the Favorites folder.
	ApplyTheme	Applies the specified theme to the workbook.
	BeginInit	Infrastructure.
	BreakLink	Converts formulas linked to other Microsoft Office Excel sources or OLE sources to values.
	CanCheckIn	Gets a value that indicates whether Microsoft Office Excel can check in the workbook to a server.
	ChangeFileAccess	Changes the access permissions for the workbook. This might require an updated version to be loaded from the disk.
	ChangeLink	Changes a link from one document to another.
	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 closes the workbook.
	CheckInWithVersion	Sends the workbook from the local computer to a server, and sets the local workbook to read-only so that it cannot be edited locally. Calling this method closes the workbook.
	CheckValidState	(Inherited from RemoteComponent.)
	Close	Closes the workbook.
	CreateRibbonExtensibilityObject	Returns an object that implements the Microsoft.Office.Core.IRibbonExtensibility interface.
	CreateRibbonObjects	Returns an array of OfficeRibbon objects to the CreateRibbonExtensibilityObject method.
	DeleteNumberFormat	Deletes a custom number format from the workbook.
	Dispose	Overloaded.
	Dummy16	Infrastructure.
	Dummy17	Infrastructure.
	EnableConnections	Enables data connections within the workbook.
	EndInit	Infrastructure.
	EndReview	Terminates a review of a file that has been sent for review using the SendForReview method.
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	ExclusiveAccess	Assigns the current user exclusive access to the workbook that is open as a shared list.
	ExportAsFixedFormat	Saves a workbook in PDF or XPS format.
	Finalize	(Inherited from RemoteComponent.)
	FinishInitialization	(Inherited from EntryPointComponentBase.)
	FollowHyperlink	Displays a cached document, if it has already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application.
	ForwardMailer	Infrastructure.
	get_Colors	Infrastructure. Use the Colors property instead of this method.
	GetAutomationObject	Called by the Visual Studio Tools for Office runtime to get an object that can be used by VBA code in the workbook.
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetHostItem<(Of <(T>)>)	(Inherited from RemoteComponent.)
	GetPrimaryControl	Infrastructure.
	GetService	(Inherited from RemoteComponent.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	GetVstoObject	Returns a workbook host item that extends the functionality of the specified native Excel workbook.
	GetWorkflowTasks	Returns the collection of workflow tasks for the workbook.
	GetWorkflowTemplates	Returns the collection of workflow templates for the workbook.
	HasVstoObject	Returns a value that indicates whether an Excel Microsoft.Office.Tools.Excel..::.Workbook host item has been created for the specified native Excel Microsoft.Office.Interop.Excel..::._Workbook.
	HighlightChangesOptions	Controls how changes are shown in a shared workbook.
	Initialize	Infrastructure. (Overrides EntryPointComponentBase..::.Initialize()()().)
	InitializeControl	(Inherited from RemoteComponent.)
	InitializeDataBindings	(Inherited from EntryPointComponentBase.)
	LinkInfo	Gets the link date and update status.
	LinkSources	Returns an Array of links in the workbook.
	LockServerFile	Locks the workbook on the server to prevent modification.
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	MergeWorkbook	Merges changes from one workbook into an open shared workbook.
	NewWindow	Creates a new window.
	OnBindingContextChanged	(Inherited from EntryPointBindableComponentBase.)
	OnShutdown	Infrastructure. (Overrides EntryPointComponentBase..::.OnShutdown()()().)
	OnStartup	Infrastructure. (Overrides EntryPointComponentBase..::.OnStartup()()().)
	OpenLinks	Opens the supporting documents for a link or links.
	PivotCaches	Gets a Microsoft.Office.Interop.Excel..::.PivotCaches collection that represents all the PivotTable caches in the specified workbook.
	PivotTableWizard	Creates a Microsoft.Office.Interop.Excel..::.PivotTable object.
	Post	Posts the workbook to a public folder. This method works only with a Microsoft Exchange client connected to a Microsoft Exchange server.
	PrintOut	Prints the workbook.
	PrintOutEx	Prints the workbook.
	PrintPreview	Shows a preview of the object as it would look when printed.
	Protect	Protects a workbook so that it cannot be modified.
	ProtectDocument	Called by the Visual Studio Tools for Office runtime so that you can reapply password protection to the workbook after the cached data has been saved.
	ProtectSharing	Saves the workbook and protects it for sharing.
	ProtectSharingEx	Saves the workbook and protects it for sharing.
	PurgeChangeHistoryNow	Removes entries from the change log for the workbook.
	RecheckSmartTags	Causes a foreground smart tag check to occur automatically annotating data that was not annotated before.
	RefreshAll	Refreshes all external data ranges and PivotTable reports in the workbook.
	RejectAllChanges	Rejects all changes in the shared workbook.
	ReloadAs	Reloads a workbook based on an HTML document, using the specified document encoding.
	RemoveCustomization	Removes the Visual Studio Tools for Office customization from the workbook.
	RemoveDocumentInformation	Removes all information of the specified type from the workbook.
	RemoveUser	Disconnects the specified user from the shared workbook.
	Reply	Infrastructure.
	ReplyAll	Infrastructure.
	ReplyWithChanges	Sends an e-mail message to the author of a workbook that has been sent out for review, notifying him or her that a reviewer has completed review of the workbook.
	RequestService	Returns an object that implements the Microsoft.Office.Core.IRibbonExtensibility interface in a document-level customization.
	ResetColors	Resets the color palette to the default colors.
	Route	Routes the workbook, using the workbook's current routing slip.
	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.
	Save	Saves changes to the workbook.
	SaveAs	Saves changes to the workbook in a different file.
	SaveAsXMLData	Exports the data that has been mapped to the specified XML schema map to an XML data file.
	SaveCopyAs	Saves a copy of the workbook to a file but does not modify the open workbook in memory.
	sblt	Infrastructure.
	SendFaxOverInternet	Sends the active sheet in the workbook as a fax to the specified recipients.
	SendForReview	Sends a workbook in an e-mail message for review to the specified recipients.
	SendMail	Sends the workbook by using the installed mail system.
	SendMailer	Infrastructure.
	set_Colors	Infrastructure. Use the Colors property instead of this method.
	SetLinkOnData	Sets the name of a procedure that runs whenever a DDE link is updated.
	SetPasswordEncryptionOptions	Sets the options for encrypting the workbook using a password.
	SetPrimaryCookie	(Inherited from RemoteComponent.)
	ToggleFormsDesign	Toggles Microsoft Office Excel into and out of design mode.
	ToString	Returns a String that represents the current Object. (Inherited from Object.)
	Unprotect	Removes protection from the workbook. This method has no effect if the workbook is not protected.
	UnprotectDocument	Called by the Visual Studio Tools for Office runtime so that you can remove password protection from the workbook and enable cached data to be saved.
	UnprotectSharing	Turns off protection for sharing and saves the workbook.
	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 has not changed since the workbook was loaded, the in-memory copy of the workbook is not reloaded.
	UpdateLink	Updates a Microsoft Office Excel, DDE, or OLE link (or links).
	WebPagePreview	Displays a preview of the workbook as it would look if saved as a Web page.
	XmlImport	Imports an XML data file into the current workbook.
	XmlImportXml	Imports an XML data stream that has been previously loaded into memory.

Top

Explicit Interface Implementations

---

	Name	Description
	IEntryPoint..::.FinishInitialization	(Inherited from EntryPointComponentBase.)
	IEntryPoint..::.Initialize	(Inherited from EntryPointComponentBase.)
	ISupportInitializeControl..::.InitializeControl	Infrastructure.
	IEntryPoint..::.InitializeDataBindings	(Inherited from EntryPointComponentBase.)
	IActivatable..::.OnNew	Infrastructure.
	IActivatable..::.OnOpen	Infrastructure.
	IEntryPoint..::.OnShutdown	(Inherited from EntryPointComponentBase.)
	IServiceProviderCallback..::.RequestService	Infrastructure.

Top

See Also

---

Reference

Workbook Class

Microsoft.Office.Tools.Excel Namespace