Expand Minimize

Application.AddIns Property (Excel)

Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Add-Ins command on the Developer tab). Read-only.

expression .AddIns

expression A variable that represents an Application object.

Using this method without an object qualifier is equivalent to Application.Addins.

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 AddIns("Analysis ToolPak").Installed = True Then 
 MsgBox "Analysis ToolPak add-in is installed" 
 MsgBox "Analysis ToolPak add-in is not installed" 
End If
© 2015 Microsoft