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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate the type of test cases which can be automated and which cannot be automated?

965


What is the difference between keyword view and expert view?

1023


Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji

2657


What is the expert view?

939


Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..

4831


Which advantages helping QTP to hold the position of "Market Leader" for such a long period?

1782


What is quicktest professional (qtp window?

975


What are the two types of repositories available, explain them?

969


can any body give the banking domain concepts/links

4019


Explain the concept of how quicktest professional (qtp) identifies object?

952


What are the major/ important methods, functions in QTP we use realtime testing

2732


In qtp, how you can exit for loop?

949


What is the difference between byref and byval in qtp?

1008


How you will rate urself in QTP in the range of 0 to 5

2151


How to use the object spy in quicktest professional 8.0 version?

932