Open-source projects categorized as vba-excel

Top 9 vba-excel Open-Source Projects

  • VBA

    Code Blocks relating to everything VBA (by AllenMattson)

  • QRCodeLibVBA

    QR Code generator library in VBA

  • Scout APM

    Truly a developer’s best friend. Scout APM is great for developers who want to find and fix performance issues in their applications. With Scout, we'll take care of the bugs so you can focus on building great things 🚀.

  • VBA-SQL-Library

    Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.

  • Vincenty-Excel

    Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).

    Project mention: calculate distance using latitude and longitude excel | reddit.com/r/excel | 2022-09-14
  • JustMoreVBA

    A collection of code snippets, modules, and classes that I've written and collected over the years.

    Project mention: [POWERPOINT] Save slides to a new PowerPoint without opening a temporary PowerPoint (Presentation1) window | reddit.com/r/vba | 2022-10-01

    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)

  • VBA-ExtendedDictionary

    Dictionary object that extends the Scripting.Dictionary

    Project mention: Update database with two similar workbooks | reddit.com/r/vba | 2022-02-02

    If you're working with dictionaries, this might help.

  • excel-formula-print

    VBA macro to print formulas with variable names

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • SQLiteC-for-VBA

    SQLite library for VBA wrapping ADODB and SQLite C-language API.

    Project mention: [EXCEL] SQLite C/ADO VBA library with reflection | reddit.com/r/vba | 2021-12-13

    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).

  • VBA-macros

    Some VBA macros for personal use

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2022-10-01.

vba-excel related posts


What are some of the best open-source vba-excel projects? This list will help you:

Project Stars
1 VBA 269
2 QRCodeLibVBA 59
3 VBA-SQL-Library 50
4 Vincenty-Excel 36
5 JustMoreVBA 11
6 VBA-ExtendedDictionary 8
7 excel-formula-print 1
8 SQLiteC-for-VBA 1
9 VBA-macros 0
Workflow assistant built for devs & their teams
Automate the mundane part of your day, with live actionable messages for your GitHub & Jira tasks.