troubleshooting Question

How to open HP ALM from excel VBA

Avatar of sai sai
sai sai asked on
Microsoft ExcelVBA
3 Comments2 Solutions370 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros