AddIn Properties

Name

Returns

Description

Connect

Boolean

Whether the COM Add-In is currently connected (active). Can be set to True to load and run the Add-In. Similar to the Installed property of an Excel Add-In.

Description

String

The text that appears in the Description box of the VBE Add-In Manager.

Guid

String

Read-only. Returns the globally unique identifier for the Add-In. The Guid is created by Excel/VB when the Add-In is compiled.

Object

In the Add-In's OnConnection method, it can expose an object to the VBE (typically the root class of its object model, if it has one). You can then use the Add-In's Object property to access this object and, through it, the rest of the Add-In's object model. Few Add-Ins currently expose an Object.

ProgId

String

Read-only. Returns the program ID for the Add-In, which is composed of the name of the Add-In project and the name of the connection class (usually a connection designer). For example, if you have an Add-In project called MyAddin and an Add-In Designer class called dsrMyConnection, the ProgId will be "MyAddin.dsrMyConnection".

0 0

Post a comment