I use excel files with vba, under LibreOffice. After installing version 3.5 of LibreOffice, vba works at the beginning, but when I save file(in MSoffice 2003 format) and close it and after that open it again, the vba macros do not work.
If I use OOo and version 3.3 of LibreOffice it works . What is the difference ?
Hi @pawnbroker1997, Have you been able to find an answer to your question? I believe that @mmohrhard may be correct regarding LO’s ability to output VBA code into an Excel file, however that functionality may have been implemented in the last few months. Please let us know how things are going for you!
As far as I understand the concept, the VBA is converted to Star Basic when it is imported to Libre Office. Then when you save it in Excel format it can’t convert it back to VBA.
I am not sure about this, but I think it is the reason for your problem.
BR. GrN.dk
This is wrong. We can’t save vba macros correctly back. We just copy the vba stream back into the file.
Also we don’t convert VBA macros to StarBasic. They are still Vba macros, we just don’t have a feature for saving them back into the file.
Take a look in:
Menu/Tools/Options/Load-Save/VBA properties