AddIn Object and the Addins Collection

The Addins collection holds all of the Addin objects available to Excel. The Add-In must be installed (AddIn.Installed = True) to be able to use it in the current session. Examples of available Addin objects in Excel include the Analysis Toolpack, the MS Query Add-In, and the Conditional Sum Wizard.

The Add method of the Addins collection can be used to add a new Addin to the collection. The Add method requires a FileName to be specified (usually with an XLL or XLA file extension). The Count property of the Addins collection returns the number of Add-Ins that are available for use by the current Excel session.

0 0

Post a comment