SQLiteC-for-VBA
SQLite library for VBA wrapping ADODB and SQLite C-language API. (by pchemguy)
Rubberduck
Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE). (by rubberduck-vba)
| SQLiteC-for-VBA | Rubberduck | |
|---|---|---|
| 1 | 24 | |
| 5 | 1,956 | |
| - | 0.9% | |
| 0.0 | 8.7 | |
| about 3 years ago | 23 days ago | |
| VBA | C# | |
| 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.
SQLiteC-for-VBA
Posts with mentions or reviews of SQLiteC-for-VBA.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-12-13.
-
[EXCEL] SQLite C/ADO VBA library with reflection
Complete project source code with dependencies is available from the GitHub repo and the project documentation - from the GitHub pages site. I perform unit testing under x32/VBA6 (Excel XP/2002 SP3) and x64/VBA7 (Excel 2016) environments. With the entire repository cloned on Windows 10 and the two dependencies (the SQLiteODBC driver and the RubberDuck VBA add-in) installed, the following two quick checks can be executed right away from the immediate pane. This command ?LiteMan(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version used by the SQLiteODBC driver (usually embedded), e.g., 3.23.3, and this command ?SQLiteC("").CreateConnection(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version loaded by the project, e.g., 3.37.0. The project also includes a set of examples, which should also run out-of-the-box (see documentation).
Rubberduck
Posts with mentions or reviews of Rubberduck.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-27.
- Rubberduck – A free and open-source VBIDE add-in
- In a world that runs on Excel, why should I as an engineer learn python?
- Welche Marke/Firma hat euch als Kunde verloren und warum?
-
What’s the best IDE?
But, with the RubberduckVBA plugin, the editor certainly becomes very usable.
-
Code Review - Is this clean code?
I agree - it generally looks pretty clean in general. Do you use Rubberduck? If not, I'd run the Code Inspections - it will always find some best practices that you missed and you can tweak the output to your preference.
-
I’m making a vbaProject.bin packager in python and looking for anyone with opinions!
I suppose this is like the opposite of this project: https://rubberduckvba.com
-
Is it for bath time?
It's a great plugin for VBA: https://github.com/rubberduck-vba/Rubberduck
-
Open source projects looking for contributors
This project is extending the VB6 IDE?
- does everyone know about rubber duck? I love this little plugin
-
Eve Online fans cheer Microsoft Excel features at annual Fanfest
A lot of Runescape resource to XP / hours calculators. What they really need to do is replace VBA with a proper programming interface. Rubberduck VBA [1] Adds some essential features into the VBA IDE but they really just need to add C# support directly.
[1]: https://rubberduckvba.com/
What are some alternatives?
When comparing SQLiteC-for-VBA and Rubberduck you can also consider the following projects:
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
EvilClippy - 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.
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
Excel-Pomodoro-Timer - Excel Pomodoro Timer
Elasticsearch .NET - This strongly-typed, client library enables working with Elasticsearch. It is the official client maintained and supported by Elastic.