vba-test
Add testing and TDD to VBA on Windows and Mac (by VBA-tools)
stdVBA
VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications. (by sancarn)
Our great sponsors
| vba-test | stdVBA | |
|---|---|---|
| 2 | 67 | |
| 194 | 254 | |
| 1.5% | - | |
| 0.0 | 8.5 | |
| about 2 years ago | 3 days ago | |
| VBA | VBA | |
| MIT License | MIT License |
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.
vba-test
Posts with mentions or reviews of vba-test.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-04-04.
-
I created a fluent unit testing framework in VBA
Yup, this framework is a bit different from traditional unit testing frameworks. In addition to the ones you mentioned, vba-test is another popular one. This framework is in the fluent style. It was inspired by Fluent Assertions in C#.
-
Best practices for building / testing code?
If you want to go fancy, i.e. Unit Testing (kinda), have a look at vba-test.
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-11-15.
-
Why do people still use VBA?
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...)
-
Writing a Compiler is Surprisingly Easy (part 1)
You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
-
Is the era of the self-taught dev over?
The responses I got was a mix. Some businesses didn't take me seriously because the main language I used was VBA. Some businesses claimed I was too eager and I "didn't have a life". No one seemed to care about the achievements I had made in the languages, like building a DSL in VBA, or this electron app. I did eventually get a job in another engineering firm though, where I spend 90% of my time to this day programming.
-
Best Practice in Aggregating Data
Really depends what you actually want to do and how neat (or fast) you want your code to be too... I typically use stdEnumerator and stdLambda from stdVBA.
-
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
-
Why does VBA give general statement for errors and not exact?
That said it is effort. After building stdLambda which brings lambda syntax to VBA, I can tell you that error handling in this class is still trash. It's just a lot of effort to write good error messages, and handle all errors correctly. Still definitely an item on the TODO list, but will it ever be a priority? idk
-
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 :)
-
[EXCEL] How do I get the accName of a control via AccessibleObjectFromWindow
Use stdVBA's stdAcc:
-
/r/VBA PSA: ChatGPT is incredibly good at writing basic VBA code if you give it clear instructions of what you want it to do and how
Explaining code in such a way that it codes the correct thing is pretty awful though... Let's try to do that for stdTimer.
What are some alternatives?
When comparing vba-test and stdVBA you can also consider the following projects:
Fluent-VBA - An object-oriented fluent unit testing library for VBA
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
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.
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBA-Project-Information - VBA Project Information
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-Unit-Tester
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBAPackager - Based on Evil Clippy, designed to package VBA documents (WIP)
vba-test vs Fluent-VBA
stdVBA vs ECPTextStream
stdVBA vs VBAChromeDevProtocol
stdVBA vs Rubberduck
stdVBA vs VBA-CSV-interface
stdVBA vs VBCorLib
stdVBA vs VBA-Project-Information
stdVBA vs VBA-SQL-Library
stdVBA vs VBA-Unit-Tester
stdVBA vs VBA-JSON-parser
stdVBA vs VBA-ExtendedDictionary
stdVBA vs VBAPackager