How to check if a COM object is registered

[Totto]

Hi,
Is there a way to check if a COM object is registered in VBA(Excel).
I'm currently using CreateObject() and just lets it fail, is this the way to
do it ?

 

[Karl E. Peterson]

Is there a way to check if a COM object is registered in VBA(Excel).
I'm currently using CreateObject() and just lets it fail, is this the way to
do it ?

That's certainly the easiest, yeah.

 

[Galin Iliev]

hi
try this code )
this is the way

Dim aaa
On Error Resume Next
Set aaa = CreateObject("TSCGWebInstallere.Update")
If Err.Number = 449 Then
MsgBox "The com is not registered"
GoTo end_exit:
End If
' The com not registered here
end_exit:


Galin Iliev
MCSD