Top 5 VBA vba-excel Projects
-
-
VBA-SQL-Library
Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
-
SonarLint
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
-
If you're working with dictionaries, this might help.
-
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).
-
Shameless plug, but I wrote an Excel macro that displays the formula in terms of its variables. Makes checking a breeze. And super easy to paste into Word if you are creating a report.
VBA vba-excel related posts
- Update database with two similar workbooks
- [EXCEL] Loop theory
- excel - pasting from dictionary into sheet1
- Best way to query a set of data in vba?
- [EXCEL] Checking one data table for information relative to another one using VBA
- Good general Mechanic Calculation Suite?
- How do i find out how many times a duplicate value appear in a column of data?
Index
What are some of the best open-source vba-excel projects in VBA? This list will help you:
Project | Stars | |
---|---|---|
1 | QRCodeLibVBA | 47 |
2 | VBA-SQL-Library | 45 |
3 | VBA-ExtendedDictionary | 8 |
4 | SQLiteC-for-VBA | 1 |
5 | excel-formula-print | 0 |
Are you hiring? Post a new remote job listing for free.