troubleshooting Question


Avatar of RWayneH
RWayneHFlag for United States of America asked on
SAPVisual Basic ClassicProgramming
15 Comments1 Solution544 ViewsLast Modified:
I can not find the QTP category to post this in....  so I am posting this in SAP and other

I am setting up some testing in QTP (HP QuickTest Pro / HP Quality Center). I made edits to the default.xls so that my datatables have the most current copy of the test plan so I do not have to import anything... and when the file opens in QTP it is all there.  Now as I perform the code in the test, it populates a Pass/Fail parameter for each line item of the test and we are going down the list sequentially and populating based on test results.

Sheet name to TestPlan and the first parameter on that sheet is "Task" and there is a naming convention there. TP01.01, TP01.02, 03 .. and so on.

Issue is when coding it, it is cell specific, so after a test is preformed it places pass or fail in parameter "PassFail" on the "TestPlan" sheet. We all know that the TestPlan gets shifted about and folks want to add, take away and move tasks around.

If we have the result determined in a variable called "TaskResult", is there a way to search the QTP sheet for that task, when found enter the value of TaskResult in the parameter "PassFail" of the row? This way it does not matter the sequence the task are coded in.  It is similar to the use of offset active.cell in Excel.  It is driven by the written tests that are occurring by the code. If that Task is not coded yet, I can put a default of "NotCoded" in the cell that are left in the PassFail parameter that are blank.

Has anyone done this before? and is there any suggested code that I could use for this? Trying to get a design direction on how to get around having to statically assigning values in a datatable.

Please advise and thanks.
Gary Patterson, CISSP
Expert for hire: IBM i, AIX, Linux, Windows, DB2, Performance, Security. EDI

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 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 1 Answer and 15 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