We help IT Professionals succeed at work.

How to open HP ALM from excel VBA

sai sai
sai sai asked
on
360 Views
Last Modified: 2017-09-04
when the below code is run, ALM is not getting launched and there is no error message getting displayed.

Could you please let me know if any changes are to be made to the below code:


Dim QCConnection As Object;

Set QCConnection= createObject ('TDApiOle80.TDConnection')

Dim sUsername, sPassword

Dim sProject, sDomain


sUsername=sheet1.Range(A1).Value

sPassword=sheet1.Range(B1).Value


sProject=sheet1.Range(C1).Value

sDomain=sheet1.Range(D1).Value

QCConnection.InitConnectionEx sheet1.Range(E1).Value

QCConnection.login sUsername,sPassword

QCConnection.connect sDomain,sProject
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2011
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2011
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2011

Commented:
provided valid recommendation