AddIns Collection Object

Description

A collection of AddIn objects representing all the add-ins available to Microsoft Excel, regardless of whether they are installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).

Accessors

Use the Add method to add an add-in to the list of available add-ins.

Use the AddIns method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

The following example creates a list on the worksheet named "Sheet1" of the names and installed states of all the available add-ins.

Sub DisplayAddIns()
    Worksheets("Sheet1").Activate
    rw = 1
    For Each ad In Application.AddIns
        Worksheets("Sheet1").Cells(rw, 1) = ad.Name
        Worksheets("Sheet1").Cells(rw, 2) = ad.Installed
        rw = rw + 1
    Next
End Sub

Properties

Application Property, Count Property, Creator Property, Parent Property.

Methods

Add Method (AddIns Collection), Item Method.