Based on my own limited experience with LO, the answer is yes, but not without modification. Let me explain.
I have substantial experience with MS-Office and VBA, including developing “menu-driven Access systems using comprehensive VBA routines.” I recently began working with LO as an alternative to MS-Office.
A short while ago, I started working with LO 4.x in Windows 7 and Linux Mint, and I am now working in LO 5.x. Some of the issues I initially experienced are gone, and others seem destined to disappear. I will simply address what I observed a few days ago.
I do NOT want to enable JRE (Java Run-time Environment), yet I want to create and run code for automation and menu-driven processing (as you do). Since Javascript, Python, and Beanshell all seem to require JRE, I decided to try LO Basic on a “simple” VBA routine I wrote for one of the CPE courses I teach. The routine runs behind Excel to create loan amortization tables at the click of a button.
Using LO Calc, I opened an Excel workbook containing the VBA code and saved it to ods format. I then tried to run the code. Most of the code ran, but there were a few errors.
Since I had intentionally used Excel-specific commands in my VBA code, I expected some errors when running in LO Basic. However, only the code designating the active worksheet actually caused the routine to bomb off.
When I rem’d the active worksheet statement, the code ran to completion – albeit with certain spreadsheet cells displaying a particular error code. VBA code such as the message box at the end of the routine ran just fine in LO Basic.
I haven’t had time to research and debug my converted routine for the error code displayed in the spreadsheet cells, but I’m quite sure this will require only minimal effort. However, my test routine involves only a few dozen lines of code. The more extensive code required for “menu-driven Access systems using comprehensive VBA routines” will almost certainly require more extensive debugging effort.
One other note, since we are discussing a migration of Access code to LO Base. I currently refuse to use HSQLDB, since this also requires Java to be enabled. As I understand it, the Firebird database is quite powerful, and is currently available for experimental use in LO. I have not had time to experience the use of LO Base with Firebird, but it is definitely on my list of things to do.
I hope this answer gives you some insight into what you may be facing in your quest to use Access code in LO Base. I would encourage you to persevere, and I would love to be kept informed of your progress, since your experience might also help make me aware of problems I may face and the workarounds you have found.
Good luck.
Please click the checkmark next to the post you believe best answers your question.