Programmatically close workbooks

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 VSTO Add-in projects for Excel. 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 VSTO Add-ins.

1. 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

   Globals.ThisWorkbook.Close(false);
   

1. Call the Close method to close the active workbook. To use the following code example, run it in the ThisAddIn class in a VSTO Add-in project for Excel.

   • C#
   • VB

   this.Application.ActiveWorkbook.Close(false, missing, missing);
   

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

1. 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

   object fileName = "NewWorkbook.xlsx";
   Excel.Workbook workbook = this.Application.Workbooks.get_Item(fileName);
   workbook.Close(false);
   

• Work with workbooks
• How to: Programmatically save workbooks
• How to: Programmatically open workbooks
• Programmatic limitations of host items and host controls
• Optional parameters in Office solutions
• Host items and host controls overview