|about 1 month ago||8 months ago|
|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.
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
3 projects | /r/vba | 16 Jun 2023
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
Bulk Structured Spreadsheet Extractor
2 projects | /r/vba | 29 May 2023
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
3 projects | /r/vba | 15 Apr 2023
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.
2 projects | /r/vba | 5 Feb 2023
Worst and best of VBA
2 projects | /r/vba | 6 May 2022
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 like a proper dev?
7 projects | /r/vba | 5 May 2022
my own stdVBA and some examples at stdVBA-UI
I created a fluent unit testing framework in VBA
4 projects | /r/vba | 4 Apr 2022
There're numerous unit testors out there already. I do find it interesting as to why many prefer this result.equalTo(3) compared to result = 3. My own is a single class and goes down the Test.Assert message, x=y route. As a result most of my tests look like:
VBA And The WebDriver Dilemma
2 projects | /r/vba | 18 Mar 2022
For sharepoint you need to use SOAP. I've got a small example here
Evaluating expressions from strings in VBA
4 projects | /r/vba | 20 Feb 2022
At that point, I decided to try the fabulous stdLambda tool, developed by u/sancarn. I found that stdLambda correctly evaluated all the corner cases that made Volpi's class fail. This fact excited me, so I decided to measure the time it took to evaluate an expression with variables, noticing that the u/sancarn library was quite efficient. At that point, I started to measure the performance by evaluating functions like sin, cos, tan, abs, the results seemed strange to me when I noticed that the performance was almost 50 times lower when compared to the results obtained when measuring the performance by evaluating expressions without calls to built-in functions.4 projects | /r/vba | 20 Feb 2022
Here the explanation by the library owner:
Meet a library member: CSVTextStream, the king of performance.
2 projects | /r/CSVinterface | 8 Apr 2023
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
3 projects | /r/vba | 1 Mar 2021
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-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBA-Project-Information - VBA Project Information
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBAPackager - Based on Evil Clippy, designed to package VBA documents (WIP)