Edit

AddIns2.Item property (Excel)

  • Article

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that returns an 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.