Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Workbooks Object

Office 2007
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.

Visual Basic for Applications

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.

Visual Basic for Applications

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.

Visual Basic for Applications
Workbooks.Open FileName:="Array.xls", ReadOnly:=True

Community Additions

© 2015 Microsoft