How open an excel sheet in QTP(not a run time )?
Answer Posted / cxv
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Add
ExcelBook.Worksheets(1).Cells(1,1).Value="A"
ExcelBook.Worksheets(2).Cells(1,1).Value="Ra"
ExcelBook.SaveAs "C:\test1.xls"
ExcelApp.Quit
Set ExcelApp = Nothing
msgbox "Completed"
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is QTP scenario.
The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)
What is standalone database?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?
what is the latest version of QTP? Main difference between 9.2 and 10 version
What is qtp window?
How you can delete excel file in qtp?
which type of testing process are you following in ur company? how to recognize a qtp page?
Hi, I am using OutputCheckPoint and I am storing the value in the data table. The stored value for column:bedroom:"Bed:4" The another value for column:bathroom:"Bath:2 Full,1 Partial" I need only the no 4 from the first column. I need only the no 2,1 from the second column. I used split array,but it also show array(0) has the value"bed:4" ..... Even though I highlight only 4,It is seleting the full value "bed 4".How can I get only the nos Thank you Uma
when u script reveiwing in which area u more concentrates?
what is profile tool?
Hi ,Can any one pleas explain how to test splash objects using QTP?
Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji
What are the data types in qtp?
Explain how you can find length of array in qtp?