This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Represents a COM add-in in the Microsoft Office host application. The COMAddIn object is a member of the COMAddIns collection.
Using the COMAddIn Object
Use COMAddIns.Item(index), where index is either an ordinal value that returns the COM add-in at that position in the COMAddIns collection, or a String value that represents the ProgID of the specified COM add-in. The following example displays a COM add-ins description text in a message box.
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
For a detailed description of how to develop a COM add-in, see the chapter "Add-ins, Templates, Wizards, and Libraries" in the Microsoft Office 2000/Visual Basic Programmer's Guide.