Hi
I am new to QTP. we are planning to implement automation
for the application.
I am trying to execute the following script:
Set ExcelObj=CreateObject ("Excel.Application")
ExcelObj.WorkBooks.Add
Set NewSheet=ExcelObj.Sheets.Item(1)
NewSheet.Name="Order"
ExcelObj.Cells(1, 1).Value = "Name"
ExcelObj.Cells(1, 2).Value = "Ordernum"
ExcelObj.Cells(2, 1).Value = "nam"
ExcelObj.Cells(2, 2).Value = "21"
ExcelObj.ActiveWorkbook.SaveAs "c:\test1.xls"
ExcelObj.Quit
Set ExcelObj = Nothing
in the above script for the line(ExcelObj.Cells(2, 2).Value
= "21")
it is inserting the value 21 successfully.this is fine
But if i want to insert a variable instead of the constant
value then what should be the modification in the script.
For example: If user retrives a value
throug "GetRoProperty" and wants to insert the value into
then how the script changes?
Answer Posted / sri
Hi...don't mind...QTP Questions, u can post in Automation
Tools Section...this Section is only for Manual Testing!!!
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain quicktest professional (qtp) testing process?
I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
Why qtp always start action1 and does not start action?
To which environments does quicktest professional (qtp) supports?
What are the features of quick test pro(qtp)?
UFT 12.02 which ALM version will support
How to analyzing test results using quicktest professional (qtp)?
How to use output values in qtp ?
How many number of actions possible in qtp?
Tell some commonly used Excel VBA functions?
Explain how qtp identifies object?
What is the difference between the keyword view and expert view?
Explain how you can find length of array in qtp?
What is the limitation to XML Checkpoints?