10 Jul 2008 - 06:34:11 pm
Create an Excel File
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
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
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