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


Please Help Members By Posting Answers For Below Questions

What are the things(properties, and other details) will be recorded while recording an object using normal recording?

1495


WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT

1711


Explain in brief about the quicktest professional (qtp) automation object model?

572


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..

1802


What contains Data Driven Framework document in qtp?

1471






can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.

5108


What is the recovery scenario in qtp?

577


Object repositories types, which and when to use?

581


distinguish between old version and new version QTP features.

1865


What is the diff between image and bitmap check point?

599


How do you create regression test packs?

613


Did QTP prove efficient for your project? Yes or No, explain?

6119


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

1449


Hi All, How to Compare two strings character by character in QTP

955


In qtp, explain what is crypt object

602