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


Please Help Members By Posting Answers For Below Questions

what is the frame work in J-meter?

1596


We stored into the objects OR and then write the scripting

1539


Differentiate the type of test cases which can be automated and which cannot be automated?

563


can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks

1521


What is the Command used to start the QTP

1529






What are the different recording modes and how do they work?

610


Want to verify notepad reports using QTP framework or any other BV script method. Can anyone share the method to achieve it? Eg. Person Name is the header and the actual name is John then how can we verify weather person name is John

2163


How will you test a stapler?

592


How you can delete excel file in qtp?

591


Does quicktest professional (qtp) is unicode compatible?

536


Plz Explain How to access Or Store Script from VSS? Explain Real time work (qtp) where you store folders and next to how to you access that folders and how you maintain folders in VSS ? What are the Menu's in VSS? Suppose in Manual, by using Checkin Checkout u can access documents. how you access in QTp REal time?

1574


Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this

2059


What are the benefits of qtp?

548


How to handle Java tree in QTP?

740


If I change the property value at runtime is it effect is object repository?

602