Unable to connect Excel to ALM

Question

Trying to connect to HP ALM 12.5 from Excel using below code

qcURL = "https://xxx-alm.xxxx.com/qcbin"
qcID = "xxxxx"
qcPWD = "xxxx"
qcDomain = "xxxO"
qcProject = "xxxxxx"

'Initiate connection with ALM Server
Set oTDConnection = CreateObject("TDApiOle80.TDConnection")
oTDConnection.InitConnection qcURL, qcDomain
oTDConnection.ConnectProject qcProject, qcID, qcPWD
Set com = oTDConnection.Command

and have referenced below libraries:

If i try to run I get an error as below on the line

Set oTDConnection = CreateObject("TDApiOle80.TDConnection")

I tried with various solutions provided in forums like here, here, and here but could not resolve

Answer 1

Install HP ALM Client on your machine, it is available on your ALM server: http://almserver:8080/qcbin/start_a.jsp?common=true

Answer 2

OTA is a 32-bit COM library, you cannot use it in 64bit Office. From your screenshot, you've already had OTA Client registered in your computer, otherwise you can't see it in the "References" dialog. So, probably, you're using 64 bit Excel to invoke OTA.