VBA-SQL-Library
Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination. (by Beakerboy)
VBA-ExtendedDictionary
Dictionary object that extends the Scripting.Dictionary (by SSlinky)
Our great sponsors
| VBA-SQL-Library | VBA-ExtendedDictionary | |
|---|---|---|
| 2 | 8 | |
| 65 | 16 | |
| - | - | |
| 6.2 | 8.1 | |
| 2 months ago | 3 months ago | |
| VBA | VBA | |
| - | 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-SQL-Library
Posts with mentions or reviews of VBA-SQL-Library.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-04-16.
-
A VBA Project for Unit testing VBA with VBA. Please review, test, use, improve!
I'm willing to merge in any pull requests anyone can come up with. I use this library to run all the tests on VBA-SQL-Library.
-
stdEnumerator - Enumerate and manipulate any collection/array/class with very few statements
VBA-SQL-Library/SQLUnitTests.bas at master ยท Beakerboy/VBA-SQL-Library (github.com)
VBA-ExtendedDictionary
Posts with mentions or reviews of VBA-ExtendedDictionary.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-03-23.
-
Update database with two similar workbooks
If you're working with dictionaries, this might help.
- [EXCEL] Loop theory
-
excel - pasting from dictionary into sheet1
Using u/chunkyasparagus' example values, I populated my cExtendedDictionary and dumped it to the sheet. Took at a guess, nearly a second to run.
-
Best way to query a set of data in vba?
This was one of the things my Extended Dictionary was designed to do with the AddBulk method.
- [EXCEL] Checking one data table for information relative to another one using VBA
- How do i find out how many times a duplicate value appear in a column of data?
-
Where to use class modules
An example of where I've used a class as a tool can be found here.
- [VBA] Record unique values from a collection in an array
What are some alternatives?
When comparing VBA-SQL-Library and VBA-ExtendedDictionary you can also consider the following projects:
QRCodeLibVBA - QR Code generator library in VBA
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
vba-macros - Some VBA macros for personal use
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
SQLiteC-for-VBA - SQLite library for VBA wrapping ADODB and SQLite C-language API.
VBA-Unit-Tester
VBA-STD-Builder - A temporary project for building a VBA code builder, to allow people to work in VSCode and perform Live Tests
VBA - Code Blocks relating to everything VBA
VBA-SQL-Library vs QRCodeLibVBA
VBA-ExtendedDictionary vs VBA-JSON-parser
VBA-SQL-Library vs stdVBA
VBA-ExtendedDictionary vs stdVBA
VBA-SQL-Library vs vba-macros
VBA-ExtendedDictionary vs VBAUnicodeTools
VBA-SQL-Library vs SQLiteC-for-VBA
VBA-ExtendedDictionary vs QRCodeLibVBA
VBA-SQL-Library vs VBA-Unit-Tester
VBA-ExtendedDictionary vs SQLiteC-for-VBA
VBA-SQL-Library vs VBA-STD-Builder
VBA-ExtendedDictionary vs VBA