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