stdVBA
VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications. (by sancarn)
ECPTextStream
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA. (by ws-garcia)
Our great sponsors
| stdVBA | ECPTextStream | |
|---|---|---|
| 62 | 5 | |
| 215 | 8 | |
| - | - | |
| 0.0 | 0.0 | |
| about 1 month ago | 8 months ago | |
| VBA | VBA | |
| MIT License | GNU General Public License v3.0 only |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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
Posts with mentions or reviews of stdVBA.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-06-16.
-
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 like a proper dev?
my own stdVBA and some examples at stdVBA-UI
-
I created a fluent unit testing framework in VBA
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
For sharepoint you need to use SOAP. I've got a small example here
-
Evaluating expressions from strings in VBA
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.
Here the explanation by the library owner:
ECPTextStream
Posts with mentions or reviews of ECPTextStream.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-04-08.
-
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?
When comparing stdVBA and ECPTextStream you can also consider the following projects:
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-Unit-Tester
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)