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
How to creating an output value using quicktest professional (qtp)?
I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
In QTP can we feed the out of one browser(internet explorer) as an input to the another browser(mozilla firefox)? If yes explain how to do it with an example.
what is Property......End Property loop? how to write sript for it in QTP
How many ways is to parameterize the value?
Sql questions to find second max salary and how to use joins
i need to add 1000 users in a domain i written the script for that and it is running successfuly but the problem is that my system is not the user of that domain in which i have to add users so for adding users in that domain i have to install qtp on that another system, can anybody suggest me the way to add those users from my system ultimately i want to know how to access remote computer through script
To which environments does quicktest professional supports?
How are cgi programs, applets, javascripts, ActiveX components, etc. to be maintained, tracked, controlled, and tested?
How can i initiate the objects to find uniquely in OR
What is the parameterization? Give one example?
How to analyzing test results using quicktest professional?
How many add-ins comes by default with quicktest professional (qtp)?
How will you compare keyword and expert view?