stdVBA
ECPTextStream
Our great sponsors
stdVBA | ECPTextStream | |
---|---|---|
67 | 5 | |
244 | 11 | |
- | - | |
8.5 | 0.0 | |
14 days ago | about 1 year ago | |
VBA | VBA | |
MIT License | GNU General Public License v3.0 only |
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.
ECPTextStream
-
Meet a library member: CSVTextStream, the king of performance.
The table below shows the overall performance for the read operations, you can download the test files from here. The test machine is running Win 10 Pro 64-bit, Intel® Core™ i7-4500U CPU N2600 @1.80 GHz - 2.40 GHz, 8 GB RAM.
-
VBA CSV Interface v3 Pre-release
Parse CSV/TSV through streams with the ECPTextStream class module.
What are some alternatives?
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
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-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-Project-Information - VBA Project Information
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBAPackager - Based on Evil Clippy, designed to package VBA documents (WIP)