<div>
I haven't done this, so take this for what it is worth:<br />
<br />
If the results just get written out sequentially, can you simply output <i>both</i> the task name and the result, instead of pre-populating the spreadsheet with the task names and then trying to find the right row to update?
</div>


<div>
I suppose I could write it out to a s-sheet each time. &nbsp;In VBA how would I goto Sheet1, do a find task TP01.01 (which will be there and in column A). &nbsp;When it is found, goto column H and put in a &quot;Passed&quot;. (or Failed). &nbsp;I have a variable called TestResult, if TestResult = True Then &quot;Passed&quot; and if TestResult = False Then &quot;Failed&quot;.<br />
<br />
I did not want to not have to do this after each test but I can trigger excel code inside of QTP. &nbsp;It just seems to me that it could be done in QTP also. &nbsp;The work around would be to do this in Excel
</div>


<div>
row = Application.WorksheetFunct<wbr />ion.Match(<wbr />xxx, Range(&quot;A1:A200&quot;), 0)
</div>


<div>
Confused by the VBA reply, it looks like it is only finding the row?<br />
<br />
is xxx what it is searching for in column A, &nbsp;how do I get Passed or Failed in column H? &nbsp;Also what if column A has more than 200 lines? &nbsp;I do not want to limit the search and want to keep it dynamic. &nbsp;Shouldn't it use offset on the row found to place the Pass or Fail result in it? &nbsp;<br />
<br />
Seach column A for task &nbsp;(TP01.01) and when found put the word &quot;Passed&quot; in column H of the row that was found.
</div>


<div>
I don't understand how you're getting your data to Excel. &nbsp;Are you using Excel automation from your QTP script (I've see QTP scripting done in vbscript)? &nbsp;Are you just exporting from QTP using a custom xsl (you said xls above - is that just a typo?).
</div>


<div>
One of the hard parts of this assignment is the need to use QTP, so I edit the default.xls in QTP contain the master test plans. &nbsp;I then run SAP (from QTP and Excel) and use the import and export functions in QTP to compile the data. &nbsp;(Excel when I do not know how to do a task in QTP, I run Excel macros inside of QTP by creating an Excel object, a workbook object and a sheet object, so I can write to the excel sheets from QTP, &nbsp;then with that workbook open, I can call to any of the macros in it.<br />
<br />
I am importing to QTP using commands like:<br />
DataTable.ImportSheet&quot;C:\Q<wbr />TP\ImportF<wbr />ileForQTP.<wbr />xls&quot;,&quot;SOLN<wbr />Data&quot;,&quot;SOL<wbr />NData&quot;<br />
Which imports a sheet tab from Excel to QTP and then when I want to export back to an Excel file I use commands like:<br />
Datatable.Export(&quot;C:\QTP\T<wbr />estingScen<wbr />arios\Thir<wbr />dParty\TP0<wbr />1 - Customer Change - New Catalog Code\Third party Scenario 1a Results.xls&quot;) &nbsp; 'needs to use .xls, no xlsx, ?xlsm?<br />
<br />
I do most of the work in VBA, and have scripted full test scenarios there, but I now have a requirement to begin using QTP and Quality Center. &nbsp;I run a lot of macros inside of QTP that are triggered in QTP by using commands like:<br />
myxl.Application.Run &quot;MacroToUseInQTP.xlsm!Buil<wbr />dAnUploadN<wbr />AXML&quot;<br />
<br />
I am still learning the QTP side, but if there are ways to get a result by use VBA I do.<br />
<br />
The current need is in VBA, how do I tell excel to find a cell value (TP01,01) which will be in column A, and when found, enter the value of &quot;Passed&quot; in column H. &nbsp;After I populate the excel piece that way, I can import/replace that sheet tab in QTP by re-importing the sheet into QTP.<br />
<br />
I know that it sounds odd and it is a lot of back and forth etc, but I am having issues finding good documentation on running SAP in QTP. &nbsp;I have mastered running SAP from Excel and collecting data, as there are many ways to do this depending on your access in SAP. &nbsp;Hope this helps.<br />
<br />
EE does not have a QTP section but does have good Excel/VBA support. &nbsp;Do you know of any good QTP to SAP, and SAP to QTP resources? &nbsp;My hope is that I can replace all the places in QTP that I have to goto Excel and perform a task, write it to Excel, then write it to QTP or import it...
</div>


<div>
Unfortunately, I don't have any experience with QTP (now called UFT) in an SAP environment.<br />
<br />
I do know that SAP provides direct support for testing using QTP - they even provide a couple of QTP licenses under some types of enterprise support agreements. &nbsp;I'm sure that SAP or HP, or both offer training, documentation, and consulting services.<br />
<br />
It sounds to me like you are accustomed to using your own tools to automate SAP testing. &nbsp;I suspect that QC+QTP does a lot of the things you'd typically do manually - so instead of trying to force-fit your current tools and methodology, you may just want to start fresh and do things the &quot;HP way&quot; - use the tools the way they were designed. &nbsp;QTP already has a mechanism for setting up your test plans, executing them, and producing reports - so I can't help but wonder if there is a real need to do this at all.<br />
<br />
From what I can see, there is a pretty sophisticated eco-system between SAP and HP for testing automation. &nbsp;It also looks like there are multiple tools, plug-ins, version dependencies, and more than we could get into here anyway. &nbsp;This may not be a &quot;learn it all yourself&quot; sized task. &nbsp;<br />
<br />
I wish I had more to offer, but as I've mentioned this just isn't my area of expertise. &nbsp;Hopefully another expert has more to offer.<br />
<br />
Personally, I'd start by contacting the appropriate SAP and HP support resources and ask them for help. &nbsp;My guess is that is going to be the best place to find training, documentation, and technology services. &nbsp;It looks like there are some specific components that inter-operate, and there may be some optional components for QTP that you need to obtain and install to get the best integration.<br />
<br />
<a href="http://www8.hp.com/us/en/software-solutions/unified-functional-testing-automation/?jumpid=reg_r1002_usen_c-001_title_r0001" rel="ugc nofollow">http://www8.hp.com/us/en/software-solutions/unified-functional-testing-automation/?jumpid=reg_r1002_usen_c-001_title_r0001</a><br />
<br />
<a href="http://h30499.www3.hp.com/t5/Functional-Testing-QTP/ct-p/sws-Fun_Test" rel="ugc nofollow">http://h30499.www3.hp.com/t5/Functional-Testing-QTP/ct-p/sws-Fun_Test</a><br />
<br />
<a href="http://h30499.www3.hp.com/t5/The-Future-of-Testing-Blog/Using-SAP-structured-parameters-in-HP-Unified-Functional-Testing/ba-p/6202025#.VHzDkck_fAE" rel="ugc nofollow">http://h30499.www3.hp.com/t5/The-Future-of-Testing-Blog/Using-SAP-structured-parameters-in-HP-Unified-Functional-Testing/ba-p/6202025#.VHzDkck_fAE</a><br />
<br />
Here's a short article that talks about the interrelationships between SALP Solution Manager, SAP TAO, HPQC, and QTP/UFE:<br />
<br />
<a href="http://martijndevrieze.net/2012/11/13/test-automation-on-sap-is-it-really-that-much-different/" rel="ugc">http://martijndevrieze.net/2012/11/13/test-automation-on-sap-is-it-really-that-much-different/</a>
</div>


<div>
I have reviewed these and they did help a little. &nbsp;Even posted to some of the discussion boards to see if anyone knows of a good book/resource that had scripting examples for SAP and QTP... &nbsp;getting no replies. &nbsp;I find it odd that SAP promotes the use of QPT/UTP with their product, but not finding some detailed coding examples to review...<br />
<br />
Also thought it was odd the EE does not have QTP/UPT category for help.. &nbsp;must be there are no experts it?<br />
<br />
I have google searched to find some you tubes and other posts on QTP but none that work with SAP examples.<br />
Hope to find something to help... without having to pay big $$ to goto a conference or training sessions. &nbsp;There must be some folks out there that have used QTP with SAP... &nbsp;(I hope). &nbsp;Still looking..
</div>


<div>
Odds are sap and or hp have all the documentation and materials you might want. &nbsp;May just not be published publicly. &nbsp;Call SAP support and HP support and ask them what they have. &nbsp;If you still can't find what you need post back here and ill try to help.
</div>


<div>
I have a post out on the SAP Community forum that has been out there for days now. &nbsp;I have not approached this from the HP side. &nbsp;Not giving up. &nbsp;Thanks.
</div>


<div>
Just looked and Help.sap.com seems to have a lot of testing documentation.
</div>


<div>
Thanks, not sure if I been to that one yet. &nbsp;I have been on SAP's main site looking. &nbsp;I will give that a try.
</div>


<div>
Odd, I went to the website and typed QTP and no searches found. &nbsp;Same for UTP??
</div>


<div>
Thanks for the help looking into this..
</div>


<div>
<div class="content wysiwyg-content">
I can not find the QTP category to post this in.... &nbsp;so I am posting this in SAP and other <br />
<br />
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. &nbsp;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.<br />
<br />
Sheet name to TestPlan and the first parameter on that sheet is &quot;Task&quot; and there is a naming convention there. TP01.01, TP01.02, 03 .. and so on.<br />
<br />
Issue is when coding it, it is cell specific, so after a test is preformed it places pass or fail in parameter &quot;PassFail&quot; on the &quot;TestPlan&quot; sheet. We all know that the TestPlan gets shifted about and folks want to add, take away and move tasks around.<br />
<br />
If we have the result determined in a variable called &quot;TaskResult&quot;, is there a way to search the QTP sheet for that task, when found enter the value of TaskResult in the parameter &quot;PassFail&quot; of the row? This way it does not matter the sequence the task are coded in. &nbsp;It is similar to the use of offset active.cell in Excel. &nbsp;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 &quot;NotCoded&quot; in the cell that are left in the PassFail parameter that are blank.<br />
<br />
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.<br />
<br />
Please advise and thanks.
</div>
</div>


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.

QTP and SAP

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.