Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we open an Excel sheet through the script

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


Please Help Members By Posting Answers For Below Questions

How to save your test using quicktest professional?

1045


Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers

2064


if numbers are always changing write a script for that

4198


explain structured testing? plz guys with exp. do answer

1871


Dis advantages of XML checkpoint ?

2011


I have qtp 9.5 demo ver,I am not able to record the yahoo broeser.so anyone can tell me what setting i have to do in QTP for yahoo brower recording. why its not recognise the object of yahoo browser????

2713


What are the Application Functions available in QTP?

2031


An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))

2131


Why do you create a text checkpoint on a Web application? What is the purpose of the Close method?

1843


How do you configure QTP AND Test director?

1934


Why bpt?

1054


I want to do QTP Certification what is the pattern of Question paper.

2161


Where is the Bitmap checkpoint information stored?

2309


What do you to script when objects are removed from application?

1062


In qtp, explain what is keyword driven automation framework?

1049