VBA-ExtendedDictionary
JustMoreVBA
Our great sponsors
VBA-ExtendedDictionary | JustMoreVBA | |
---|---|---|
8 | 1 | |
16 | 16 | |
- | - | |
8.1 | 3.8 | |
3 months ago | 8 months ago | |
VBA | Visual Basic 6.0 | |
MIT License | GNU Affero General Public License v3.0 |
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-ExtendedDictionary
-
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
JustMoreVBA
-
[POWERPOINT] Save slides to a new PowerPoint without opening a temporary PowerPoint (Presentation1) window
And if all else fails, use a Win32 API and bruteforce your way through until you get your own way... that's what I do!! (link)
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBA - Code Blocks relating to everything VBA
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
Vincenty-Excel - Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
QRCodeLibVBA - QR Code generator library in VBA
Excel-Pomodoro-Timer - Excel Pomodoro Timer
SQLiteC-for-VBA - SQLite library for VBA wrapping ADODB and SQLite C-language API.
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.