Edit

Share via

Application.COMAddIns property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.