How to export data from Visual Basic to "OpenOffice.org Calc" spreadsheet?

Light Poster
20Aug2007,10:41   #1
akn_my_183a's Avatar
Good Days,
I have a problems exporting data from VB to "OpenOffice.org calc" spreadsheet? It is totally different from Microsoft Excel..
Hope to get u all assistances..

thank u very much
Team Leader
20Aug2007,11:46   #2
pradeep's Avatar
What is the exact problem you are facing??
Light Poster
20Aug2007,12:04   #3
akn_my_183a's Avatar
the most problem i am facing is i dont know how to code it. It's unlike Microsoft Excel..

dim oExcel as Excel.Application
dim oWs as Excel.Worksheet
dim 0Wb as Excel.workbook
.
.
.
.
.

but for OpenOffice.org calc, i dont know how to export data from VB to this kind of spreadsheet.
Team Leader
20Aug2007,12:07   #4
pradeep's Avatar
Create a normal Excel file, OpenOffice supports MS Excel format!
Light Poster
20Aug2007,12:11   #5
akn_my_183a's Avatar
In my company, all the pc are using free software, "OpenOffice.org". Now i was assigned to create programs to generate reports. If they use Microsoft Products, i can still manage to do it. Now it's different....