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
How does one get complete compatibility with VBA
Using MS Office.
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.
Asked: 2020-08-21 14:23:50 +0100
Seen: 118 times
Last updated: Aug 23 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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.