VBA-Better-Array
SQLiteC-for-VBA
Our great sponsors
VBA-Better-Array | SQLiteC-for-VBA | |
---|---|---|
8 | 1 | |
82 | 2 | |
- | - | |
4.8 | 0.0 | |
2 months ago | about 1 year ago | |
VBA | VBA | |
MIT License | MIT License |
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-Better-Array
-
Iām making a vbaProject.bin packager in python and looking for anyone with opinions!
Hesitate to mention it because I haven't had time to look at the enhancement we talked about this weekend at all š but yeah I do use a script like that to import the bas/cls files from the repo into a new workbook every time I do a pull request. https://github.com/Senipah/VBA-Better-Array/blob/master/scripts/createDevWorkbook.ps1
-
VBA like a proper dev?
Senipah's Better array
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).
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
SQLiteForExcel - A lightweight wrapper to give access to the SQLite3 library from VBA.
QRCodeLibVBA - QR Code generator library in VBA
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
vscode-data-preview - Data Preview šø extension for importing š¤ viewing š slicing šŖ dicing š² charting š & exporting š„ large JSON array/config, YAML, Apache Arrow, Avro, Parquet & Excel data files
excel-formula-print - VBA macro to print formulas with variable names
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.