Hello,
I recently switched from MS Excel 2013 to LibreOffice 5 Calc (5.1.6.2) and a macro that previously worked in Excel, is failing in LibreOffice.
When I click on the macro, the error display is “Basic runtime error. ‘323’ Module cannot be loaded; invalid format”
Does anyone know what the problem is, or how to troubleshoot?
Thanks in advance!
Hello @gil_happy,
Please post here your Excel macro that fails in LibreOffice, so that we could give it a try and translate it into LibreOffice Basic…
Just add the macro text to your original question by clicking on the “Edit” button below your question.
When I click on the macro, the error box pops up and then another window opens up (Object Catalog - My Macros & Dialogs, etc). I then just copied and pasted the data into a text file; see attached.
The problem is, obviously, in the fact that Line LibreOffice does not fully support VBA, only very simple macros can theoretically run in LO. So, you have to rewrite your macro in StarBasic.
Thank you for that info (I’m not a developer, so I had no clue)… I ‘might’ need to continue using this single spread sheet in Excel.
Hello @gil_happy,
Unfortunately, as already stated by @gabix, this means that your macro would have to be almost entirely rewritten in LibreOffice Basic.
On the other hand, if you specify exactly what the macro should be doing, then i think more people would be able to help you to write code for that, instead of trying to interpret an unfamiliar dialect.
HTH, lib
Thank you for replying… rather than leaning on everyone to help write (or re-write the macro), I think I will just wait as I will be hopefully getting a new Windows PC in the next month or so and then I can just switch back to Excel.