Interested to Buy Any Domain ? << Click Here >> for more details...
How can we open an Excel sheet through the script
- 8 Answers
- 44472 Views
- eSymbiosis, I also Faced
- E-Mail Answers
Answer Posted / sreekanth chilam
HI All,
Try for this three ways given below :
1.
SystemUtil.Run "excelsheet path"
2.
Dim xl
Set xl=CreateObject("Excel.Application")
xl.Visible=True
xl.WorkBooks.Open "ExcelSheet path"
xl.ActiveWorkBook.Save
xl.Application.Quit
Set xl=Nothing
3.Dim xl
Set xl=CreateObject("WScript.Shell")
xl.Run "Excel.exe"
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is environment variable in qtp and why to use it?
What is clean sweep?
What is the expert view?
Hai anyone please "Explain about Framework in QTP?"
What is reusable action?
To which environments does quicktest professional (qtp) supports?
Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)
How can you write the scripts that operate on different objects depending on run-time information?
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail
Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji
how will load the object during runtime?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
what is the difference between IE & Netscape in web testing on a log in page
what is ODC and GDC?
