Workbooks object (Excel)

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 of the Application object to return the Workbooks collection. The following example closes all open workbooks.


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.


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



See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.