View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excel macros and Open Office suite

hi
MS office uses VBA while open office uses OOo basic. i have heard that the
two languages are similar but different enough to be not that compatable.
There are tutorials on OOo basic on the net but at my last hearing, none
that compare VBA and OOo basic side by side.

hopefully someone who knows more about OOo basic will come along and post a
more incouraging post but i think you may be looking at a tab bit of
re-writing.

Regards
FSt1

"NDBC" wrote:

I have written some code in Excel 2003. Another person is trying to operate
the spreadsheet in Open Office Suite (I am assuming the free version) and
none of the macros work. I have checked security levels etc and had a bit of
a play but to me it looks like the code in Open Office is different to that
in Microsoft Excel. Is this right and is there any chance of getting the
macros to work in Open Office without re-writing the whole thing.

Thanks