Application.COMAddIns Property

  • Article
Excel Developer Reference

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

See Also