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.
Worst and best of VBA
2 projects | reddit.com/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 | reddit.com/r/vba | 5 May 2022
my own stdVBA and some examples at stdVBA-UI
Click a button on the ribbon
As you can see sometimes these techniques can get rather complicated, however in reality most of the complexities of this task can be hidden behind an abstraction. This is where I suggest the use of the stdVBA library. This library (created by myself) contains some simple abstractions of the IAccessible API and work in conjunction with stdLambda to help you create small utilities like the above, with very little effort:
I give up.
Uses stdVBA's stdAcc library, but works a charm! :D
Using Mail Merge and VBA to create a merge that pulls from multiple rows that have a matching cell
You'd need to download stdLambda, stdEnumerator and stdICallable and import these into your VBA library in order to work with them.
I created a fluent unit testing framework in VBA
4 projects | reddit.com/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:
tips to improve speed - general
1 project | reddit.com/r/vba | 21 Mar 2022
Yes, i created it as part of stdVBA
VBA And The WebDriver Dilemma
2 projects | reddit.com/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 | reddit.com/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 | reddit.com/r/vba | 20 Feb 2022
Here the explanation by the library owner:
stdEnumerator - Enumerate and manipulate any collection/array/class with very few statements
9 projects | reddit.com/r/vba | 10 Apr 2021
Long term, I have 2 projects VBA-Packager which attempts to do text->xlsm source injection, and VBA-Compiler which attempts to do vba-like --> vba compilation. The latter project of which is likely to be deprecated in a new project in the future. We'll see :)
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBA-CSV-interface - The most powerful and comprehensive CSV/TSV/DSV data management library for VBA, providing parsing/writing capabilities compliant with RFC-4180 specifications and a complete set of tools for manipulating records, fields and files.
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
stdVBA-Compiler - VBA-like source to VBA source code compiler
ExceLint - Finds formula errors in spreadsheets (plugin for Microsoft Excel)
VBA-STD-Builder - A temporary project for building a VBA code builder, to allow people to work in VSCode and perform Live Tests