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 are the things(properties, and other details) will be recorded while recording an object using normal recording?
WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT
Explain in brief about the quicktest professional (qtp) automation object model?
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
What contains Data Driven Framework document in qtp?
can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.
What is the recovery scenario in qtp?
Object repositories types, which and when to use?
distinguish between old version and new version QTP features.
What is the diff between image and bitmap check point?
How do you create regression test packs?
Did QTP prove efficient for your project? Yes or No, explain?
In order to select an automation tool for automating ur application, what r the things u need to consider? For eg i will go for automation; 1) When there is a lot of retesting and regression testing. 2) Return on investments. 3) Whether the tool supports the appln. 4)--------------, etc. Pls give me more number of points because my answer did not satisfy the interviewer. Very urgent pls
Hi All, How to Compare two strings character by character in QTP
In qtp, explain what is crypt object