How open an excel sheet in QTP(not a run time )?
Answer Posted / king
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Add
ExcelBook.Worksheets(1).Cells(1,1).Value="Ankush"
ExcelBook.Worksheets(2).Cells(1,1).Value="Raju"
ExcelBook.SaveAs "C:\test1.xls"
ExcelApp.Quit
Set ExcelApp = Nothing
msgbox "Completed"
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What are the different types of recovery operation?
how to find that tools work well with ur existing system?
I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.
what QTP Options do you know?
How can you handle exceptions in qtp?
How can i initiate the objects to find uniquely in OR
An action has both shared and local OR associated with it and both have the same object in them. In the test which one will be considered?
what are the mandatory properties for a tex boxc (scenario?)
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
why you have standardized functions? plzzz guys with real time exp. do answer
What is environment variable in qtp and why to use it?
How will you handle java tree in qtp?
Hybrid framework supports Descriptive programming. Is it true?
How to use descriptive programming?
In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?