automation framework,webtable methods,close browsers,creationtime,connecting database,connectionstring,connceting sql server database,access database

RAMU
Create an Excel File
10 Jul 2008 - 06:34:11 pm
Following script will create an Excel file and types some value(Hello) and saves it in C Drive

Below code will be helpful for creating  and closing excel sheet

Dim xlApp
Dim xlBook
Dim xlSheet

Set xlApp=CreateObject("Excel.Application")
Set xlBook=xlApp.workbooks.add
Set xlSheet=xlBook.activesheet
xlSheet.cells(1,1)="helloo"


xlBook.saveas "C:\test.xls"
xlApp.quit
Ramu · 80 views · 1 comment
Categories: Excel Object

Permanent link to full entry

http://ramupalanki.shared-blogs.com/Automation-b1/Create-an-Excel-File-b1-p15.htm

Comments

No Comment for this post yet...


Leave a comment

New feedback status: Published





Your URL will be displayed.

 
Please enter the code written in the picture.


Comment text

Options
   (Set cookies for name, email and url)


  

Last Comment

How to get the Browser window ...

2008-11-20 @ 12:41:11 pm
by venugopal


there are many problems we will ...

2008-07-16 @ 03:58:49 pm
by Ramu


what r the challenges have faced ...

2008-07-15 @ 10:57:24 am
by veerachary


attached the answers of the above ...

2008-07-10 @ 04:38:52 pm
by Ramu


Can you please provide the answers ...

2008-07-10 @ 04:07:58 pm
by chakri


Calendar

August 2010
SunMonTueWedThuFriSat
 << < > >>
  12345
6789101112
13141516171819
20212223242526
2728293031  

Announce

Who's Online?

Member: 0
Visitor: 1

Choose a skin



Links