SQLiteC-for-VBA
Rubberduck
Our great sponsors
| SQLiteC-for-VBA | Rubberduck | |
|---|---|---|
| 1 | 24 | |
| 4 | 1,852 | |
| - | 0.9% | |
| 0.0 | 8.7 | |
| over 2 years ago | 3 months ago | |
| VBA | C# | |
| MIT License | GNU General Public License v3.0 only |
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
-
[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
- 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?
SQLiteForExcel - A lightweight wrapper to give access to the SQLite3 library from VBA.
leetcode-excel - Solutions to leetcode problems, written in the Microsoft Excel programming language (TM)
excel-formula-print - VBA macro to print formulas with variable names
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
QRCodeLibVBA - QR Code generator library in VBA
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-Better-Array - An array class for VBA providing features found in more modern languages
PhotoDemon - A free portable photo editor focused on pro-grade features, high performance, and maximum usability.
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
RegExr - RegExr is a HTML/JS based tool for creating, testing, and learning about Regular Expressions.
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
Elasticsearch .NET - This strongly-typed, client library enables working with Elasticsearch. It is the official client maintained and supported by Elastic.