I tried to establish ALM connectivity through excel VBA using OTA API.
Steps done : 1. Downloaded the OTAClient.dll and added reference to excel macro (Tools->References) .
2. Sub QCConnect()
Set objQCConnection = CreateObject("TDApiOle80.TDConnection")
Dim sUserName, sPassword
sUserName = "username" '<-- Change me.
sPassword = "password" '<-- Change me.
objQCConnection.InitConnectionEx "serverpath" '<-- Change me.
objQCConnection.Login sUserName, sPassword
3. On running the code , i received the error as : Run-time error '429' : ActiveX component can't create object
Any help here that would be great.
What version of ALM are you using?
Have you performed a "HP ALM Client Registration" ?
... just another Tester ...
OTAClient.dll is not enough. OTA Client uses WebClinet.dll to connect to ALM Server. So you will need to download and register it with regsvr32 command or "HP ALM Client Registration" too.