Last Comment

replica watches,breitling,cartieris a ...

2010-03-03 @ 07:12:51 am
by rolex


replica watches,rolex watches,replica ...

2010-03-03 @ 07:11:12 am
by rolex


How to get the Browser window ...

2008-11-20 @ 07:11:11 am
by venugopal


there are many problems we will ...

2008-07-16 @ 10:28:49 am
by Ramu


what r the challenges have faced ...

2008-07-15 @ 05:27:24 am
by veerachary


Calendar

March 2010
SunMonTueWedThuFriSat
 << < > >>
 123456
78910111213
14151617181920
21222324252627
28293031   

Announce

Who's Online?

Member: 0
Visitor: 1

Choose a skin



Links

    RAMU PALANKI
    Posts displayed of the category: Excel Object

    10 Jul 2008 
    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 · 70 views · 0 comments
    Categories: Excel Object