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 / 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


Please Help Members By Posting Answers For Below Questions

How many types of parameters are available in quicktest professional (qtp)?

976


Explain advantages and disadvantages kdf?

906


What is data driver in qtp? Where we use it?

963


What is the extension of qtp local repository?

948


what is command for executing files?

1948


Suggest and Define a solution for an application whose objects are not recognized by UFT?

1050


Diff b/w Health care domain and Banking Domain?

4647


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

1017


What is checkpoints for quicktest professional (qtp)?

978


Differences between quicktest professional (qtp) and winrunner?

1099


write the vb script for call to new action in qtp?

2236


If the objects hierarchy is changing from build to build, then how you will handle that condition?

996


How does you test a weblink which is changing dynamically?

954


If you giving priority as p0, as a developer if I give priority as p2, What happens In user defined function ?

977


I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?

1131