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.