0

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: enter image description here

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

Set oTDConnection = CreateObject("TDApiOle80.TDConnection")

enter image description here

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

braX
  • 11,506
  • 5
  • 20
  • 33
Vinod
  • 376
  • 2
  • 11
  • 34

2 Answers2

0

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

Sergi
  • 990
  • 5
  • 16
0

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.

Mike He
  • 21
  • 3
  • 1
    Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 17 '21 at 05:05