stdVBA
VBA-SQL-Library
Our great sponsors
stdVBA | VBA-SQL-Library | |
---|---|---|
67 | 2 | |
244 | 65 | |
- | - | |
8.5 | 6.2 | |
14 days ago | about 1 month ago | |
VBA | VBA | |
MIT License | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
stdVBA
-
Why do people still use VBA?
Honestly, this is something I've been wanting to do for a while... Last I looked though, I couldn't find many good resources on how WASI (or the byte code) worked... And VBA being single threaded might make things difficult too...
I have already built my own code interpreter in VBA to make Lambda syntax possible: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda.... so I know it's definitely possible, just haven't figured out WASM yet...
I do RPA from VBA personally using IAccessiblity. See stdAcc (https://github.com/sancarn/stdVBA/blob/master/src/stdAcc.cls) and an example (https://github.com/sancarn/stdVBA-examples/tree/main/Example...)
I have invested copious amounts of time into building VBA libraries (https://github.com/sancarn/stdVBA) and as much as I love vba there are some highly limiting actual problems with VBA (https://sancarn.github.io/vba-articles/issues-with-vba.html) which really hurt the language. But yes a large portion of the hate VBA gets is from the state of VBA projects (https://sancarn.github.io/vba-articles/why-is-vba-most-dread...)
-
Writing a Compiler is Surprisingly Easy (part 1)
I have an open source compiler-interpreter for VBA here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
In case you were interested :P
You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
-
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
-
Bulk Structured Spreadsheet Extractor
Otherwise this library poses as an example of how to use stdVBA libraries. Libraries used in this project: stdEnumerator, stdArray, stdCallback, stdCOM, stdICallable, stdLambda, stdRegex.
-
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
If you want a solution though see stdSettings. There are both system and user settings. Users are bound by their domain, so should work across organisations :)
- Creating a bot for automation.
-
Worst and best of VBA
Aha motivations for stdVBA which is a library I made. It resolves some of these points in some ways. E.G. stdLambda acts as a Lambda syntax for VBA. stdCallback allows you to ripe the benefits of first class functions, without those functions existing.
VBA-SQL-Library
-
A VBA Project for Unit testing VBA with VBA. Please review, test, use, improve!
I'm willing to merge in any pull requests anyone can come up with. I use this library to run all the tests on VBA-SQL-Library.
-
stdEnumerator - Enumerate and manipulate any collection/array/class with very few statements
VBA-SQL-Library/SQLUnitTests.bas at master ยท Beakerboy/VBA-SQL-Library (github.com)
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
QRCodeLibVBA - QR Code generator library in VBA
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
VBA-Unit-Tester
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBA-Project-Information - VBA Project Information
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBAPackager - Based on Evil Clippy, designed to package VBA documents (WIP)
MVVM - Model-View-ViewModel Infrastructure for VBA/VB6