Collapse the table of content
Expand the table of content
Expand Minimize

Application.AddIns2 Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns an AddIns2 collection that represents all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Read-only

expression .AddIns2

expression A variable that returns an Application object.

This example displays the status of the Analysis ToolPak add-in. Note that the string used as the index to the AddIns collection is the title of the add-in, not the add-in’s file name.

If Application.AddIns2("Analysis ToolPak").Installed = True Then 
 MsgBox "Analysis ToolPak add-in is installed" 
 MsgBox "Analysis ToolPak add-in is not installed" 
End If
© 2015 Microsoft