COMAddIn Object

Represents a COM add-in in the Microsoft Office host application. The COMAddIn object is a member of the COMAddIns collection.

Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Example

Use COMAddIns.Item(index), whereis either an ordinal value that returns the COM add-in at that position in the COMAddInscollection, or a Stringvalue that represents the ProgID of the specified COM add-in. The following example displays a COM add-in's description text in a message box.

MsgBox Application.COMAddIns.Item("msodraa9.ShapeSelect").Description

Use the ProgID property of the COMAddin object to return the programmatic identifier for a COM add-in, and use the Guid property to return the globally unique identifier (GUID) for the add-in. The following example displays the ProgID and GUID for COM add-in one in a message box.

MsgBox "My ProgID is " & _ Application.COMAddIns(1).ProgID & _ " and my GUID is " & _ Application.COMAddIns(1).Guid

Use the Connect property to set or return the state of the connection to a specified COM add-in. The following example displays a message box that indicates whether COM add-in one is registered and currently connected.

If Application.COMAddIns(1).Connect Then MsgBox "The add-in is connected." Else MsgBox "The add-in is not connected." End If

See also:

• Object Model Reference
• COMAddIn Object Members