Returns or sets the state of the connection for the specified COMAddIn object. Read/write Boolean.
The Connect property returns True if the add-in is active; it returns False if the add-in is inactive. An active add-in is registered and connected; an inactive add-in is registered but not currently connected.
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