VBA Excel

Open-source VBA projects categorized as Excel | Edit details

Top 9 VBA Excel Projects

  • VBA-Better-Array

    An array class for VBA providing features found in more modern languages

    Project mention: VBA like a proper dev? | reddit.com/r/vba | 2022-05-05

    Senipah's Better array

  • Excelerator

    This is an Excel Addin for Windows that reads and writes data to Snowflake (by Snowflake-Labs)

    Project mention: Power Query in Excel connecting to Snowflake | reddit.com/r/snowflake | 2022-04-24

    Not directly applicable but may be relevant at some point if using excel frequently - the excelerator add in. I believe it was developed by snowflake professional services, but important to note not an official product of snowflake themselves. https://github.com/Snowflake-Labs/Excelerator

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

  • pacellman

    Pac-Man in Excel

  • VBA-General

    A repository of various modules and classes for interacting with Excel and doing other... things.

    Project mention: (VBA) Starting at B4 I want to count how many cells in row 4 until the cell saying "Grand Total" is reached. | reddit.com/r/excel | 2022-03-18

    What are you doing with this project overall? (Also you can view more of where those functions came from here)

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

    Project mention: Export from MS Project to MS Excel | reddit.com/r/projectmanagement | 2021-08-27

    If needed, you may use: https://github.com/PopovGP/Export-MS-Project-to-MS-Excel

  • VBA-CSV

    Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.

    Project mention: A new year, a new tool to work with CSV files. Happy holidays! | reddit.com/r/vba | 2021-12-23

    I tried VBA-CSV, but I guess there is some Excel/Office specific code in there.

  • geo_vba

    A geographic toolkit/library for VBA, excel etc.

    Project mention: I have 400 locations in Excel; how can I easily add their addresses into the same sheet? | reddit.com/r/excel | 2022-02-24

    Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

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

  • excel-formula-print

    VBA macro to print formulas with variable names

    Project mention: Good general Mechanic Calculation Suite? | reddit.com/r/engineering | 2021-06-09

    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.

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

VBA Excel related posts

Index

What are some of the best open-source Excel projects in VBA? This list will help you:

Project Stars
1 VBA-Better-Array 68
2 Excelerator 39
3 pacellman 37
4 VBA-General 36
5 Export-MS-Project-to-MS-Excel 13
6 VBA-CSV 10
7 geo_vba 4
8 SQLiteC-for-VBA 1
9 excel-formula-print 0
Find remote jobs at our new job board 99remotejobs.com. There are 7 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com