Item Property (AddIns Collection)

Applies To

AddIns collection object.

Description

Returns a single AddIn object from an AddIns collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns an AddIns object.

Index Required Variant. The name or index number of the add-in.

Example

This example displays the status of the Analysis ToolPak add-in. Note that the string used as the index to the AddIns method is the Title property of the AddIn object.

If AddIns.Item("Analysis ToolPak").Installed = True Then
    MsgBox "Analysis ToolPak add-in is installed"
Else
    MsgBox "Analysis ToolPak add-in is not installed"
End If