Ask Your Question
0

How does one get complete compatibility with VBA

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

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

Comments

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

mauricio gravatar imagemauricio ( 2020-08-21 17:03:54 +0100 )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 +0100 )edit

2 Answers

Sort by » oldest newest most voted
4

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

How does one get complete compatibility with VBA

Using MS Office.

edit flag offensive delete link more

Comments

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 +0100 )edit
2

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

Zizi64 gravatar image

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

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

Stats

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

Seen: 118 times

Last updated: Aug 23 '20