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.
| Visual Basic for Applications |
|---|
Set objAI = Application.COMAddIns
MsgBox "Number of COM add-ins available:" & _
objAI.Count
|