Workbook.Item

Returns the specified item by name or id. This property is read only.

Syntax Parameters Return value
ReadOnly Property Workbook.Item( _
    Identifier As Variant) As WorkbookItem
Identifier [in]

The name or ID of the workbook item to access.

Type: Variant

SVB Example

Accessing workbook items by name

Option Base 1
Option Explicit
Sub Main
    Dim w As New Workbook
    w.InsertFile(Path & "\Examples\Datasets\Adstudy.sta",w.Root)
    w.InsertFile(Path & "\Examples\Datasets\IrisDat.sta",w.Root)
    'Set an item to the active input by name
    w.ActiveInput = w.Item("Adstudy")
    w.Visible = True
End Sub