Title: Programming OpenOffice Calc from XSI
Hi,
Have written some scripts recently to pipe information from XSI into Excel sheets which has been nice and dandy.
Looks like Microsoft Office products are too much of an overhead here so OpenOffice is the new software of choice within the organisation.
Does anyone know if it's possible to access OpenOffice Calc in the same way as Excel?
e.g. instead of
Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Add
Set objSheet = objExcel.ActiveWorkbook.Worksheets(1)
objSheet.Name = "JOB Data Sheet 1"
will I be able to do something like:
Set objExcel = CreateObject("Calc.Application")
etc.
Has anyone been down this road yet?
Many thanks,
Adam.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.9 - Release Date: 22/01/2008 00:00
