Excel macros and Open Office suite

N

NDBC

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
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top