Ask Your Question

How does one get complete compatibility with VBA

asked 2020-08-21 14:23:50 +0200

dwc309 gravatar image

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

edit retag flag offensive close merge delete


Always, it's better, migrate to LiboBasic. Yes, thousands of lines of VBA code too.

mauricio gravatar imagemauricio ( 2020-08-21 17:03:54 +0200 )edit

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.

dwc309 gravatar imagedwc309 ( 2020-08-24 15:41:25 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-08-21 14:26:08 +0200

How does one get complete compatibility with VBA

Using MS Office.

edit flag offensive delete link more


And even in that case, there are problems. Ask, for example, users of Microsoft Office 2008 on Macs.

gabix gravatar imagegabix ( 2020-08-21 14:46:51 +0200 )edit

answered 2020-08-22 07:50:14 +0200

Zizi64 gravatar image

updated 2020-08-23 08:42:26 +0200

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-21 14:23:50 +0200

Seen: 131 times

Last updated: Aug 23 '20