n013

7 ms·

1.
by n013 7mo ago
>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 strat
2.
by n013 7mo ago
Link to the subject: https://ecp-solutions.github.io/ASF/Language%20reference.htm...
3.
Monkey Patching in VBA(ecp-solutions.github.io)
46 points by n013 7mo ago|14 comments
4.
by n013 7mo ago
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 Va
5.
Sandboxed script execution from VBA with support for module system(github.com)
1 points by n013 8mo ago|1 comments
6.
by n013 9mo ago
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.
7.
by n013 9mo ago
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.
8.
Hacking VBA to support native scripting runtime with no COM dependencies(github.com)
24 points by n013 9mo ago|10 comments
9.
CSV dialect sniffing, potential CleverCSV enhancement(github.com)
1 points by n013 3y ago|1 comments
10.
by n013 3y ago
I found a paper, having a GitHub repository, that describes a new methodology that can be an improvement for the famous CleverCSV Python library.