n013

>VBA is permanently disabled in most large corporate and government environments these days as a security precaution.

This is exactly the argument used for deprecating a so powerful language, but It's all a Microsoft marketing strategy. Organizations creating and running only their workbooks are equally enforced to shutting down VBA, Why? Because VBA doesn't pay Microsoft rent.

Link to the subject: https://ecp-solutions.github.io/ASF/Language%20reference.htm...

At VBA side the code is clean and highly manageable.

Sub RunModule() Dim eng As New ASF

    ' Set working directory
    eng.InjectVariable "wd", ThisWorkbook.Path
    
    ' Execute module file
    Dim result As Variant
    result = eng.Execute(ThisWorkbook.Path & "\main.vas")
    
    Debug.Print result

End Sub

ASF isn't just a framework, is a modern language that we can run inside VBA.

Honestly, ASF is literally sandboxed. Objects cannot be injected in the runtime. Also, VBA Expressions is intentionally limited to receive and return VBA strings. So, the system is safe for execute code from (almost) anyone.

You can inspect the AST in order to debug your code. For syntax highlighting, use tools like Notepad++ (ASF shares most of the syntax with Javascript). Each piece of code is commented, no obscure machine code.

I found a paper, having a GitHub repository, that describes a new methodology that can be an improvement for the famous CleverCSV Python library.