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 to open Excel sheet & write in it & save it?



how to open Excel sheet & write in it & save it?..

Answer / guest

Set excel = CreateObject ("EXCEL.Application")
excel.Caption = "Test Caption"
excel.Visible = True
Set doc = excel.Workbooks.Add()
Set selection = excel.Selection
With selection
.Cells(1,1).Value = "Test value"

End With
doc.SaveAs("E:\Excel.xls")
excel.Quit

Is This Answer Correct ?    10 Yes 1 No

Post New Answer

More QTP Interview Questions

How to Parameterize Object repository in QTP?

6 Answers   Cognizant, IIBM,


Hello Everyone, In QTP we have one option Data Driver wizard that comes in Tools -> Data Driver. so, please tell me abtout the use of Add Value and Parameterize options available in Data Driver wizard. And also the concept of value, constants, Parameterized displayed in the wizard. Please explain by giving the example. Thanks in advance, Gaytri

2 Answers  


Is the qtp course will help to create a virtual object?

0 Answers  


How to change the scripts from Per-Action object repository to shared object repository

1 Answers  


what is descriptive.create()in qtp?

4 Answers   IBM,


a title of first page is "LKO- microsoft internet explorer", of the second page is "PPM- microsoft internet explorer" , of Third page is "TTS- microsoft internet explorer" and same changing title on the fourth page. How can we use regular expression for this feature what should we do on script part on and Object repository part so that we can get successful run result. Kindly explain the steps script.

2 Answers  


What is the Command used to start the QTP

0 Answers   HCL,


What is smart identification?

2 Answers   AZTEC,


What kind of errors can b handled in QTP in real time scenario?

2 Answers   AZTEC,


Could you please suggest a book to start with QTP and also a book for advanced concepts?

2 Answers  


i want to learn testing tools what i have to know before.iam fresher i dnt know any this..which langagues i have to before testing.

2 Answers   Wipro,


how can u find the syntax errors or other script errors in your test during the execution of your QTP Test - (i.e., not after the execution/test run finished, but before finishing the test run)

2 Answers   HCL,


Categories