Class AddIn (Excel VBA)
The class AddIn represents a single add-in, either installed or not installed.
Member in collection
To use a AddIn class variable it first needs to be instantiated, for example
Dim adi as AddIn Set adi = AddIns(Index:=1)
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.
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.