Excel.Workbooks.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbooks object (Excel)	vbaxl10.chm202072	vbaxl10.chm202072	Excel.Workbooks	f768da57-013a-e652-0f5d-60b03aa4240a	04/03/2019	medium

Workbooks object (Excel)

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

Remarks

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

Example

Use the Workbooks property of the Application object 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

Methods

• Add
• CanCheckOut
• CheckOut
• Close
• Open
• OpenDatabase
• OpenText
• OpenXML

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]