AddIns.Item Property (Excel)
Returns a single object from a collection.
Syntax
expression .Item(Index)
expression A variable that represents an AddIns object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Index |
Required |
Variant |
The name or index number of the object. |
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 ThisWorkbook.Application.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