>Have the following code:
>

>xl = createobject("excel.application")
>xl.workbooks.open(filfrom)
>fd = substr(DT,7,2) + substr(DT,1,2) + substr(DT,4,2) + CAMT + ".XLS"
>filto = pth + fd
>xl.sheets(1).select
>xl.cells(1,6).value = "AMOUNT"
>xl.ActiveWorkbook.SaveAs(filto)
>xl.ActiveWorkbook.Saved = .T.
>xl.ActiveWorkBook.Close()
>xl.Quit
>

>I thought there was a way to be able to do this without having msExcel installed, that microsoft provided the objects for free as a special package.
>Actually, I would prefer to be able to do this with openOffice, so if anyone knows if this is doable in OpenOffice2.2 and how to do it, please lmk.

Re: VFP and Open Office Thread #1187223 Message #1190447

(you may want to review the whole thread).

See also
http://kosh.datateamsys.com/~danny/OOo/VisualFoxPro-OOo/LibOOo-2003-11-17-01.prg
http://www.tedroche.com/Present/VFPOOoAutomation.htm
http://udk.openoffice.org/common/man/tutorial/office_automation.html