Microsoft Office Tutorials and References
In Depth Information
The AddIn object represents a single add-in that’s available to Excel. Table 11-3 contains a list
of the properties associated with a single add-in.
Table 11-3. AddIn Properties
Returns the Application object representing the creator of
Returns the CLSID of the add-in
Returns a 32-bit integer containing the binary value XCEL
Returns the full path and file name to the workbook
containing the add-in
When True , means that the add-in is installed
Returns the file name of the add-in
Returns the parent object associated with the add-in
Returns the path to the directory containing the add-in
Returns the program identifier associated with the object
The Application and Parent properties can simplify referencing the application object that
created the add-in and the parent object of the add-in.
The Creator property returns a Long value corresponding to the four characters XCEL. This
property is useful when you wish to verify that the add-in was created for Excel.
The ProgId and CLSID properties only apply when using COM or automation-based add-ins.
These properties will return an empty string for Excel add-ins.
The Name , Path , and FullName properties contain information about the file name of the
add-in’s workbook. Name contains only the file name, whereas Path indicates which direc
tory contains the add-in file. As you might expect, FullName combines the Path and Name
properties with a directory separator.
The Installed property controls whether that add-in is currently installed into Excel. Setting
this property to Tr ue installs the add-in and triggers the Workbook_AddinInstall event. Setting
this property to False removes the add-in and fires the Workbook_AddinUninstall event.