Excel VBA 429 - ActiveX component can't create object

[Shahzadt]

Hi all - I have Excel 32-bit on windows 7 professional 64-bit. I am able to create reference via tool>references to the OTAClient.dll which is provided by quality center 32-bit application but I am getting a run-time error 429. My question is what are the proper steps to take to trouble shoot this error? If anyone has dealt with this or a similar issue could point me the correct direction would be great. following is the peace of code i am trying.

Sub test()

Dim TDC As TDAPIOLELib.TDConnection
Set TDC = New TDAPIOLELib.TDConnection


TDC.InitConnectionEx ("http://server:port/qcbin")


End Sub

any help is greatly appreciated.

 

[ShawnPCooke]

Which line of code is generating the error, the Set statement or the InitConnectionEx method? That would be the first question.

If it's the Set statement, then there's some sort of issue actually creating the object. You might try using this bit of code instead:

Set TDC = CreateObject("TDAPIOLELib.TDConnection")

If it's the next statement, then I would try to find some documentation on the OTAClient.dll to see if you're doing it right. Failing at that, try contacting HP for QC support. It may not be a VBA specific issue, but rather one with the use of QC itself.

 

[Shahzadt]

below is the codeline which is causing the error

[COLOR=#333333]TDC.InitConnectionEx ("http://server:port/qcbin")[/COLOR]

i will check with hp as well.

 

[Shahzadt]

spoke with hp found out that the dll wasn't registered and registered it by going to "http://serverort/qcbin/start_a.jsp?common=true" in internet explorer.

Thanks all

 

[ShawnPCooke]

Thank you for checking back in to satisfy the curiosity of future searchers!