Excel Macro: ActiveX component can't create object: 'TDApiOle80.TDConnection' -

qcconnection error

i trying connect qcserver using excel macro. using 64-bit operation system following being done:

1. register otaclient.dll
2. installed hp alm connectivity tool
3. added ota library reference

now after still getting following error:

activex component can't create object: 'tdapiole80.tdconnection'

but same running using vb script:

c:\windows\syswow64\wscript.exe "c:\users****\desktop\qcconn.vbs"vbscript

please !!

i have found solution on other blog:

if on 64 bit machine, default script run 64 bit version of wscript.exe. qc 32 bit app, need consume 32 bit version of wscript.exe located @ c:\windows\syswow64\wscript.exe.

so can done run it, call command line prompt in macro , run command:

c:\windows\syswow64\wscript.exe   c:\users****\desktop\qcconn.vbs  

which call vbs. eg:

dim gows: set gows = createobject("wscript.shell")     scmd = "c:\windows\syswow64\wscript.exe "c:\users****\desktop\qcconn.vbs""""  set oexec = gows.exec(scmd) 

hope helps !!