This documentation is archived and is not being maintained.

Application.COMAddIns Property

Office 2007
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



Show: