Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

How to: Close Workbooks

Visual Studio 2010

You can close the active workbook or you can specify a workbook to close.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

There are two procedures for closing the active workbook: one for document-level customizations and one for application-level add-ins.

To close the active workbook in a document-level customization

  • Call the Close method to close the workbook associated with the customization. To use the following code example, run it in the Sheet1 class in a document-level project for Excel.

    C#
    VB
    Copy 
    
Globals.ThisWorkbook.Close(false, missing, missing);

To close the active workbook in an application-level add-in

  • Call the Close method to close the active workbook. To use the following code example, run it in the ThisAddIn class in an application-level project for Excel.

    C#
    VB
    Copy 
    
this.Application.ActiveWorkbook.Close(false, missing, missing);

The way that you close a workbook that you specify by name is the same for application-level add-ins and document-level customizations.

To close a workbook that you specify by name

  • Specify the workbook name as an argument to the Workbooks collection. The following code example assumes that a workbook named NewWorkbook is open in Excel.

    C#
    VB
    Copy 
    
object fileName = "NewWorkbook.xls";
Excel.Workbook workbook = this.Application.Workbooks.get_Item(fileName);
workbook.Close(false, missing, missing);
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ