Interested to Buy Any Domain ? << Click Here >> for more details...
How can we open an Excel sheet through the script
- 8 Answers
- 44754 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
you are recording on "WINDOW 1", say it has a link if you click on that, that leads you to "WINDOW 2". If you do any manipulations on "WINDOW 2" that are automatically updated in to "WINDOW 1". But "WINDOW 1" is currently invisible. But the updations in "WINDOW 1" must also be recorded as a script in QTP. The best Example is if you update your resume in JOB STREET portal it actually happens in other window, but the previous window is automatically updated. Now does QTP help you in this types of situations? Any body can answer this question. please..... Siva
I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...
How to start recording using quicktest professional (qtp)?
How is a Step generator used in UFT?
what is clean sweep?
Hi, I am supposed to automate mainframe application through qtp. I do not know how to start abt it. Can you plz help me in first initializing the process or do you anybody have a guide book or a link which guides me through the process of automating the mainframe applications and things involved in it.
Hybrid framework supports Descriptive programming. Is it true?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?
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
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
Explain the qtp test phases.
Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..
What is fragmentation and paging?
How to use parameterization in qtp?
in my application,validation message has in japanise language.how to validate this message is appears properly or not
