Item Property (Workbooks Collection)

Applies To

Workbooks collection object.

Description

Returns a single Workbook object from a Workbooks collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a Workbooks object.

Index Required Variant. The name or index number of the workbook.

Example

This example sets the wb variable to the workbook for Myaddin.xla.

Set wb = Workbooks.Item("Myaddin.xla")