Class AddIn (Excel VBA)

The class AddIn represents a single add-in, either installed or not installed.

Member in collection

Item

To use a AddIn class variable it first needs to be instantiated, for example

Dim adi as AddIn
Set adi = AddIns(Index:=1)

The following procedures can be used to set variables of type AddIn: AddIns.Add, AddIns.Item, AddIns2.Add and AddIns2.Item.

For Each

Here is an example of processing the AddIn items in a collection.

Dim adi As AddIn
For Each adi In AddIns
    adi.FullName
Next adi

AddIns.Add - Adds a new add-in file to the list of add-ins. Returns an AddIn object.

AddIns2.Add - Adds a new add-in to the list of add-ins.

Properties

AddIns.Item (Default member) - Returns a single object from a collection. AddIns2.Item (Default member) - Returns a single object from a collection.

CLSID returns a read-only unique identifier, or CLSID, identifying an object as a String.

FullName returns the name of the object, including its path on disk, as a string.

Installed true if the add-in is installed or to install the add-in; False if the add-in is uninstalled or to uninstall the add-in.

IsOpen returns True if the add-in is currently open.

Name returns a String value that represents the name of the object.

Path returns a String value that represents the complete path to the Add-in, excluding the final separator and name of the Add-in.

progID returns the programmatic identifiers for the object.

AddIns.Count returns a Long value that represents the number of objects in the collection.

AddIns2.Count returns a Long value that represents the number of objects in the collection.