Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Workbook and Workbooks class contains the methods and properties you use to perform tasks with workbooks.
Task |
Procedure |
|---|---|
Create a new workbook. |
|
Open a specified workbook. |
|
Close a specified workbook and save changes. |
|
Save workbooks in Excel formats or XML format. |
|
Bring the focus to the current workbook or a different workbook. |
|
Prevent users from adding or deleting worksheets. |
|
Set a password on a workbook or clear an existing one. |
|
Get and set the default file path for workbooks. |
|
Get a collection of recently used workbook files. |
|
Display a built-in dialog box for locating files. |
|
Send workbooks as e-mail attachments programmatically. |
|
Open XML files as workbooks. |
|
Open text files as workbooks. |
For more information about Excel tasks and the Excel object model, see Excel Object Model Overview.
In some cases, the ways that you perform these tasks in application-level add-ins is different from the ways that you perform them in document-level customizations.