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
How to connect to a database?
how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?
Hi All, I have QTP installed on my machine but the application under test is on remote machine. I need to automate the scenarios which consist of automatically enter the remote machine through IP address ,record the application in remote machine and run it also when played. Can some one tell how to record the application in remote machine.
How to associate shared object repository to test in qtp?
You will receive the mail in your outlook from client at night time to go ahead for the execution. Based on the mail you need to trigger the batch run. What is the QTP Code for this?
How did you use regular expressions in QTP and also in WR?
Through array we can execute the testcase how ? give me example
Explain the new feature of UFT regarding the export of test results?
Can any one tell me how to write a script for selecting open option in File menu of A word document.here you have to add objects to OR.try like that and give me the ans.i asked this question to so many but no one knows.if any one know the answer plz let me know
Do you know how to connect database? Can you tell me the procedures?
Which environments does qtp support?
In what occasion we can specify global sheet and action sheet?
How do you know the location Id of an object if you know its index id?
Explain xml checkpoints.
what is run-time data?