AddIns Property
Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Tools menu). Read-only.
For information about returning a single member of a collection, see Returning an Object from a Collection.
Remarks
Using this method without an object qualifier is equivalent to Application.Addins
.
Example
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"
Else
MsgBox "Analysis ToolPak add-in is not installed"
End If