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

Wher to use DATA TABLE METHODS in Qtp?What is the use of it?

8 Answers   Wipro,


What is the syntax to use out of two characters. Pls anybody can give the answer.. Thanks in advance...

1 Answers   Navis,


in how many ways you perform batchtesting?

2 Answers   Sapient,


How we know the qtp has used the smart identification process for identification of the object.

4 Answers   IBM,


what does it mean when a check point is in red color? what do u do?

4 Answers  


In QTP, Give the difference of Global sheet and Local sheet in datatable?

3 Answers  


In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?

0 Answers  


I want different types of discriptive programming statments coded for different types of web-objects?Give syntax and example?

2 Answers  


Hi How to retrieve data from web element line by line?

0 Answers  


how to test one edit box using Java addin for Web Applications? write script?

1 Answers   IBM,


How to Open FireFox using descriptive programing? If my question is not clear, i will give an Example To Open Internet Explorer, We use Set IE = CreateObject(InternetExplorer.Application) IE.Navigate "www.yahoo.com In the same i need to open yahoo.com in firefox. Can any one tell me what is the server name of firefox to create an object

0 Answers  


I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?

0 Answers  


Categories