1 out of 2 rated this helpful - Rate this topic

Workbooks Object (Excel)

Published: July 16, 2012

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.