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