Interested to Buy Any Domain ? << Click Here >> for more details...
How can we open an Excel sheet through the script
- 8 Answers
- 44824 Views
- eSymbiosis, I also Faced
- E-Mail Answers
Answer Posted / uday kumar_anem
If you want to open Excel sheet using QTP, follow the below
script:
Dim objexcel
Set objExcel = createobject("Excel.application")
Set objWB = objExcel.Workbooks.Open("FileName")
Set objWS = objExcel.ActiveWorkbook.Worksheets("SheetName")
objexcel.Visible = True
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
How to test fly out menu in qtp?
The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)
can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com
How to modify the text checkpoint?
Explain about the quicktest professional (qtp) automation object model?
How do you do batch testing in wr & is it possible to do in qtp, if so explain?
Did QTP prove efficient for your project? Yes or No, explain?
Mention the different actions types of qtp.
What is checkpoints for qtp?
Connect to QC using AOM.
What is expert view and keyword view?
How to test background color and dynamic images during run time can you put the check point for moving objects?
What is the short cut keys for the following?
How can I change object description or check point values in qtp?
What ate the Technologies supported by QTP?
