Open-source VBA projects categorized as Vba

Top 23 VBA Vba Projects

  • VBA

    Code Blocks relating to everything VBA (by AllenMattson)

  • stdVBA

    VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.

    Project mention: Passing Multiple Calculated Values to the Clipboard | reddit.com/r/vba | 2023-01-19

    So firstly, I'd suggest to pass data to and from the clipboard you use stdClipboard

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • crypto_vba

    An Excel/VBA project to communicate with various cryptocurrency exchanges APIs

  • VBA_personal

    Library with VBA, used in multiple projects.

  • msaccess-vcs-integration

    Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system. (by joyfullservice)

    Project mention: Distributing front-end file via SharePoint. | reddit.com/r/MSAccess | 2023-01-06

    This is similar to what I was thinking of doing but was just curious if because of the way SharePoint works with the user directories if I could pop an update into the folder and it would resync with the new version whenever I may updates. If it doesn't indeed play well I've got a VBA script that checks to make sure the an FE file variable matches a table in the backend and if not prompts them to update to the newest version. I've also been using msaccess-vcs-integration and it's been a life saver.

  • VBA-JSON-parser

    Backus-Naur Form JSON Parser based on RegEx for VBA

  • VBA-Better-Array

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

    Project mention: I’m making a vbaProject.bin packager in python and looking for anyone with opinions! | reddit.com/r/vba | 2023-01-20

    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

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

  • Battleship

    An Object-Oriented VBA experiment (by rubberduck-vba)

    Project mention: Is there a platform for selling Excel VBA games? | reddit.com/r/vba | 2023-01-01

    Then you need to do some research, otherwise you won't know what you're competing with! Take, the example, the version of Arkanoid made by VB6 developer - https://imgur.com/a/Z8GL0hk There are a number of projects on Github - like BattleShips by the maker of RubberDuck (the VBA Editor COM addin), Mathieu Guindon. You should check out Awesome VBA because there a few games listed to get you started.

  • QRCodeLibVBA

    QR Code generator library in VBA

  • Power-Refresh

    Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA

    Project mention: Is it possible to auto-refresh without opening a workbook? | reddit.com/r/excel | 2022-08-20

    An overkill solution but i think its the best. you can search github for another scripts that either use VBA or powershell or python.

  • wordle97

    Wordle for Word 97

    Project mention: I Recreated Wordle in Microsoft Word | reddit.com/r/shittyprogramming | 2022-06-09

    Looks (and probably works) better than my attempt with VBA :)

  • VBAIPFunctions

    IP manipulation and lookup VBA functions

    Project mention: Suggestions for a good IP range add/remove tool? | reddit.com/r/sysadmin | 2023-01-31
  • VBA-CSV-interface

    The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.

    Project mention: New version of VBA CSV Interface | reddit.com/r/vba | 2022-12-31

    As usual, at the end of the year, a new version of VBA CSV Interface is available. However, this time it is a major revision focused on refactoring code and increasing the usability of the tool.

  • VBA-General

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

    Project mention: Where/How do you take track of notes | reddit.com/r/vba | 2022-12-16

    Here's a code repo that I've had for years now.

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


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

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

    A powerful string expression evaluator for VBA, which puts more than 60 mathematical, financial, date-time, logic and text manipulation functions at the user's fingertips.

    Project mention: Evaluate piecewise functions in VBA | reddit.com/r/vba | 2022-10-17

    So, if a Dominican needs to calculate the taxes that will be charged to them monthly, they should take pencil and paper, compute the annual amount of income and apply the corresponding formula, or they can use the following code in conjunction with VBA Expressions and get their result in a simple way.

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

  • ECPTextStream

    ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.

    Project mention: [Access] Any alternatives to Scripting.TextStream that eat up less memory? | reddit.com/r/vba | 2022-05-25

    Maybe the ECPTextStream class module can help you. This library is faster than the scripting method when dealing with text files and can manage files up to 2GB without any problem. See the benchmarks here.

  • 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

  • VBAUnicodeTools

    Tools for working with Unicode in the VB Editor

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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 2023-01-31.

VBA Vba related posts


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

Project Stars
1 VBA 285
2 stdVBA 168
3 crypto_vba 148
4 VBA_personal 113
5 msaccess-vcs-integration 101
6 VBA-JSON-parser 90
7 VBA-Better-Array 81
8 Battleship 72
9 QRCodeLibVBA 60
10 Power-Refresh 57
11 wordle97 56
12 VBAIPFunctions 51
13 VBA-CSV-interface 45
14 VBA-General 41
15 Vincenty-Excel 36
16 Export-MS-Project-to-MS-Excel 16
17 VBA-CSV 15
18 JustMoreVBA 12
19 VBA-Expressions 10
20 VBA-ExtendedDictionary 9
21 ECPTextStream 6
22 geo_vba 5
23 VBAUnicodeTools 4
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives