Application.COMAddIns Property (Excel)
Returns the COMAddIns collection for Microsoft Excel, which represents the currently installed COM add-ins. Read-only.
Syntax
expression .COMAddIns
expression A variable that represents an Application object.
Example
This example displays the number of COM add-ins that are currently installed.
Set objAI = Application.COMAddIns
MsgBox "Number of COM add-ins available:" & _
objAI.Count