VBA interpreter…run VBA on Linux.

[Beakerboy]

in case you want another novel Vba toy to play around with, I have a VBA interpreter in the works. Ideal use case is to run VBA unit tests from GitHub. It has very minimal functionality right now, but it can evaluate while loops, if-then-else, and implements a stack to support function recursion.

https://github.com/Beakerboy/PyVBA-Interpreter/tree/dev

[sancarn]

That's extremely cool sounding @Beakerboy!! It'd be very cool to have some kind of automated testing!

[Beakerboy]

If you’ve ever wanted to learn how to make an interpreter, feel free to look at the tests and add your own.

[Beakerboy]

I have a bare minimum unit tester working:
https://github.com/Beakerboy/VBA-Projects/tree/Test
any subs that start with Test in any file that starts with Test in the tests directory will run.

Just add:

    - name: Test
      uses: Vba-actions/test-vba@dev

to your workflow.
caveats:

• only module(.bas files) are supported right now.
• Limited VBA Standard Library support

so Basically just math stuff right now.
Combines the features of:

• https://github.com/Beakerboy/vbaUnit
• https://github.com/Beakerboy/PyVBA-Interpreter
• https://github.com/Beakerboy/VbaStdLib

code coverage coming up soon
Next step, static analysis for Strict mode.

[Beakerboy]

Code Coverage reporting has begun:
https://coveralls.io/builds/79349332/source?filename=src%2FModules%2FRoots.bas

[sancarn]

Thanks for keeping me posted :)

I would definitely love to add some of these kind of automated tests when I find time. Especially for the likes of stdLambda.

only module(.bas files) are supported right now.

As in for the auto-execute of the Test* functions, or are classes unsupported totally even post call?

[Beakerboy]

I have to code up a wrapper for VBA classes to allow python to interact with them in a proper object-oriented fashion. The way ANTLR works, is you can pass around code execution contexts as a viariable. I need to create a VBAObject class, that an antlr visitor can populate with any PropertyContext, FunctionContext and SubroutineContext objects it picks up when scanning the code. Honestly, it could probably be vibe-coded. the Google AI could probbaly put this together along with a set of unit tests.

[dangrazh]

Inspired by this discussion I have decided to combine 2 projects, I had in mind for a bit now. It's been a while since I wanted to build a VS Code LSP Extension for VB and its been a while since I wanted to see how far one can go with AI assisted coding these days. So a few weeks back I sat down, took Codex and started specifying and building a VB interpreter & VM. In the meantime I have a first version, which covers "non-GUI" VB6 and a lot of VBA as long as it is not Office Host specific functionality (though I have a minimal Excel Host included). the functionality is still quite limited but I successfully tested against my own Data Table project and a subset of stdVBA (including stdArray, stdLambda, stdRegex, stdICallable and others) on both Windows and Linux. I was not able to test on Mac, as I do not have access to Mac infrastructure. The LSP backend comes with a LSP client for VS Code (this is not properly packaged yet, but the release-vscode.ps1 script in the \scrips folder prepares a vsix file, that can be used to install the Extension locally).

you can find the source code under https://github.com/dangrazh/OxiBASIC. Please feel free to play around with it and see if it is any good for your use cases / needs. any feedback is most welcome. (The VS Code Extension is not properly packaged yet, but the release-vscode.ps1 script in the \scrips folder prepares a vsix file, that can be used to install the Extension locally).

P.S.: I included support for Javadoc style comments rendering in the hover info of functions in VS Code, so the effort that you put into your documentation comments is properly honored... :-)

[DecimalTurn]

That's a nice project! I was personally using my fork of https://github.com/SSlinky/VBA-LanguageServer for VBA LSP functionalities in VS Code, but I noticed that performance and memory consumption could be a problem on large VBA codebases. Hopefully, Rust can help with that issue.