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

akn_my_183a's Avatar
Light Poster
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
pradeep's Avatar, Join Date: Apr 2005
Team Leader
What is the exact problem you are facing??
akn_my_183a's Avatar
Light Poster
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.
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Create a normal Excel file, OpenOffice supports MS Excel format!
akn_my_183a's Avatar
Light Poster
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....