Workbooks.Item Property (Excel)

Returns a single object from a collection.

Syntax

expression. Item( _Index_ )

expression A variable that represents a Workbooks object.

Parameters

Name Required/Optional Data Type Description
Index Required Variant The name or index number of the object.

Example

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

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

See also

Workbooks Object