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


Excel Object Model Reference

Workbooks Object Members