Workbooks Object (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

A collection of all the Workbook objects that are currently open in the Microsoft Excel application.

For more information about using a single Workbook object, see the Workbook object.

Use the Workbooks property to return the Workbooks collection. The following example closes all open workbooks.

Workbooks.Close

Use the Add method to create a new, empty workbook and add it to the collection. The following example adds a new, empty workbook to Microsoft Excel.

Workbooks.Add

Use the Open method to open a file. This creates a new workbook for the opened file. The following example opens the file Array.xls as a read-only workbook.

Workbooks.Open FileName:="Array.xls", ReadOnly:=True
Show: