I would really like to leave Office behind but have thousands of lines of VBA code that just won’t run.
I put in the line to the headers of all my vba files but still get errors.
Option VBASupport 1
Always, it’s better, migrate to LiboBasic. Yes, thousands of lines of VBA code too.
Is there a manual available? One that would describe the programming environment and perhaps have a word or two on converting VBA code to LiboBasic. Maybe it would also contrast the two, VBA 7 LiboBasic.
How does one get complete compatibility with VBA
Using MS Office.
And even in that case, there are problems. Ask, for example, users of Microsoft Office 2008 on Macs.
The LibreOffice supports many programming languages to call the API functions and procedures of the LibreOffice.
There is not (never was and never will be) a full compatibility between the LO API and the MS Office VBA.
The MS Office VBA is a “programming language + programming environment + a function library” in one.
The function library of the LO (read: the API) is fully independent from the supported programming languages and programming environments.
The StarBasic and the built-in IDE (the most obvious programming language and environment of the LO) is only one of the programming tools to call the API functions. You can call the API functions from Python, JavaScript, etc…
API: Application Programming Interface.