Subject Re: OpenOffice.org Export From Miel Castro Jr. <miel_castrojr@yahoo.com> Date Thu, 04 Feb 2010 05:08:56 -0500 Newsgroups dbase.getting-started Thanks for the response, Your suggestion is actually OK, however, I have modified some of the codes so as to format excel file in Custom Cell Ranges, which I wanted to happen in OpenOffice.org as well so I would like to know what would be the replacement of this: oExcel := new oleAutoclient("excel.application") in OpenOffice.org and this oWorkBook = oExcel.workbooks.add() oExcel.Range("A1:B10").Select()          // and merge them for our title area          //place some border...          with( oExcel.Selection.Borders )             LineStyle := xlContinuous             Weight := xlMedium             ColorIndex := xlAutomatic          endwith          with ( oExcel.Selection )                         font.name := "Arial"             font.size := 9             font.bold := true             Interior.ColorIndex := 42             Font.ColorIndex := 51 // dark green          endwith and some others: Thanks for the initiative.. God Bless! Miel --------------------------- Geoff Wass [dBVIPS] Wrote: > In article <3hoYQhVpKHA.1808@news-server>, miel_castrojr@yahoo.com says... > > Any one in this forum who could convert exporting of data to excel into exporting data into OpenOffice.org re: Spreadsheet? > > > > Thanks > > >   > Miel, > > Both programs support .CSV files which dBASE can create. If you check the on-line for the > COPY command you can see that you can use it or there is at least one utility that you can > use. > > -- > Geoff Wass [dBVIPS] > Montréal, Québec, Canada > > .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|. > .|.|.| ---------------------------------------------------------- |.|.|. > .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.