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
In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?
An action has both shared and local or associated to it and both have the same object in them. In the test which one will be considered?
What is debugging? How you debug your script?
Shall we add Local Repository to shared object repository,if yes,how we add
How to analyzing the checpoint results?
How is test case write?
What are the views available in quicktest professional (qtp)?
What is difference between shared and local object repository?
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
How QTP identify the system time that's changes every seconds?
What is quick test pro?
After executing the script in qtp suppose i found some script execute successfully and found some error.So how to report the status for both (i.e pass and fail report)in test director. For "fail" We use "defect tab" in testdirector. But for "pass" how to report it to TL.what is the process plz anybody ans
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
What is object spy in quicktest professional (qtp)?
What is the difference between run time object and test object in QTP?