Interested to Buy Any Domain ? << Click Here >> for more details...
How open an excel sheet in QTP(not a run time )?
- 4 Answers
- 10304 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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
how can i pass a "cript"as a parameter in to a function
If a button named "CLICK" is recorded in low level recording mode , what will be the values stored for "name" property of that button in object repository ?
What is recovery scenario manager? When you go for recovery scenario manager?
i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet
When should I use smart identification?
diff between qtp versions from 8.5
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
Explain how you can delete excel file in qtp?
When do go for loop condition in test?
When Recovery scenario actually starts while testing the application?
can any body give the banking domain concepts/links
How many types of recording facility are available in quicktest professional?
Name the different types of recording modes?
what are the limitations of smart identification in qtp 9.0
How Can I find the least value in a bunch of variables using qtp.. E.g.:- A = 210, B = 212, C = 60, D = 111 I don’t want to write bunch of lines for this…. Is there a way to get the result in one line…..
