Excel macros and Open Office suite
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 |
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 |
All times are GMT +1. The time now is 03:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com