stdVBA VS VBA-SQL-Library

Compare stdVBA vs VBA-SQL-Library and see what are their differences.

stdVBA

VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications. (by sancarn)

VBA-SQL-Library

Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination. (by Beakerboy)
Our great sponsors
  • Scout APM - Truly a developer’s best friend
  • talent.io - Download talent.io’s Tech Salary Report
  • SonarLint - Clean code begins in your IDE with SonarLint
stdVBA VBA-SQL-Library
47 2
153 48
- -
6.8 1.9
9 days ago 8 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.

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 2022-05-06.
  • 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
  • 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:
  • 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:
  • Good Projects
    3 projects | reddit.com/r/vba | 23 Dec 2021
    If you want to do something really useful, you can contribute to one of the many amazing libraries around like stdVBA (you can see the backlog here), CSV Interface or VBCorLib
  • Looking for a VBA math expression evaluator
    2 projects | reddit.com/r/vba | 13 Dec 2021
    Use stdLambda...? [docs]
    2 projects | reddit.com/r/vba | 13 Dec 2021
    You probably want to look through the tests if you want examples. Though the tests have explicit calls to .Run(...) and .RunEx(...).
  • [EXCEL] TUTORIAL: Populate basic ArrayList object and display contents on worksheet
    2 projects | reddit.com/r/vba | 27 Sep 2021
    Hehe yes, a tutorial would be great. I used to make youtube videos, so I will at some point make a youtube tutorial for stdVBA. But there are some reddit ones too example1, example2, and there is some docs too not complete though unfortunately.

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.

What are some alternatives?

When comparing stdVBA and VBA-SQL-Library you can also consider the following projects:

ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.

QRCodeLibVBA - QR Code generator library in VBA

VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.

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-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary

VBA-Unit-Tester

SQLiteC-for-VBA - SQLite library for VBA wrapping ADODB and SQLite C-language API.

QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel

VBAPackager - A cross-platform assistant for creating malicious MS Office documents. Can hide VBA macros, stomp VBA code (via P-Code) and confuse macro analysis tools. Runs on Linux, OSX and Windows.

VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.