OO.o 2.x – MS Interop ...

• (Excel) VBA compatibility

  • [immature – can buy Sun's macro-foo tool ]
  • simple macros work already
    • a great place to get started
  • Sub CellsProperty
  • sheet = ActiveWorkbook.ActiveSheet
  • sheet.Range("I5:K10").Cells.Select
  • Selection.FormulaArray = "=RAND()+1"
  • sheet.Range("C30:D35").Cells(0,0).Value = 12
  • sheet.Range("C30:D35").Cells(5,1).Formula = "=SUM(I5:K10)"
  • End Sub

• Access (http://mdbtools.sf.net/)

  • So far data import is ~working
    • in due course forms / macros / reports ?
  • Lots of ergonomic & cleanup work needed in 'base'