AddIns2.Item Property (Excel)
Returns a single object from a collection.
Version Information
Version Added: Excel 2010
Syntax
expression .Item(Index)
expression A variable that returns a AddIns2 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 AddIns2 method is the Title property of the AddIn object.
If ThisWorkbook.Application.AddIns2.Item("Analysis ToolPak").Installed = True Then
MsgBox "Analysis ToolPak add-in is installed"
Else
MsgBox "Analysis ToolPak add-in is not installed"
End If