Open-source VBA projects categorized as Vba | Edit details

Top 13 VBA Vba Projects

  • GitHub repo crypto_vba

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

    Project mention: VBA API call with nested JSON data | reddit.com/r/vba | 2021-12-10

    It basically uses the Dictionary object to create variables (e.g. with a dictionary in a dictionary) and after that using that library to transform it into a string. I'm using it in my project here: https://github.com/krijnsent/crypto_vba/blob/master/ModExchKucoin.bas

  • GitHub repo VBA-JSON-parser

    Backus-Naur Form JSON Parser based on RegEx for VBA

    Project mention: Accounting software glitch leads to using old/incorrect fx rates in invoices | reddit.com/r/UKPersonalFinance | 2021-12-20

    Downloaded and imported VBA-JSON-parser

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

  • GitHub repo VBA-Better-Array

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

    Project mention: Filling combobox and sorting it | reddit.com/r/vba | 2021-08-25

    u/senipah has done a lot of work extending VBA's array capabilities here. I would look into this to sort your data in memory rather than reinventing the wheel.

  • GitHub repo QRCodeLibVBA

    QR Code generator library in VBA

    Project mention: is there way create free qr code in excel? | reddit.com/r/excel | 2021-04-07

    This project offers a powerful set of tools for work with QR codes. I test it and found it very useful.

  • GitHub repo VBA-CSV-interface

    The most powerful and comprehensive CSV/TSV/DSV data management library for VBA, providing parsing/writing capabilities compliant with RFC-4180 specifications and a complete set of tools for manipulating records and fields.

    Project mention: Good Projects | reddit.com/r/vba | 2021-12-23

    If you want to do something really useful, you can contribute to one of the many amazing libraries around like stdVBA (you can see the backlog here), CSV Interface or VBCorLib

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

  • GitHub repo 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

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

  • GitHub repo VBA-ExtendedDictionary

    Dictionary object that extends the Scripting.Dictionary

    Project mention: [EXCEL] Loop theory | reddit.com/r/vba | 2021-12-30
  • GitHub repo ECPTextStream

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

    Project mention: VBA CSV Interface v3 Pre-release | reddit.com/r/vba | 2021-03-01

    Parse CSV/TSV through streams with the ECPTextStream class module.

  • GitHub repo geo_vba

    A geographic toolkit/library for VBA, excel etc.

    Project mention: Can I Create a Heat Map with Excel Data for a Downtown Area? | reddit.com/r/excel | 2021-07-14

    As u/Grey_Patagonia_Vest describes: you could add some more information like a postal code to the address. If you're looking for "main street", that will give tons of hits, if you add a postal code and/or city there is a higher chance you get to your desired location/city. I've built this toolkit, based on OpenStreetMap / Nominatim to transform addresses to lat/long -> https://github.com/krijnsent/geo_vba , using the geo_nom_search function, you could give it a try.

  • GitHub repo VBAUnicodeTools

    Tools for working with Unicode in the VB Editor

    Project mention: [VBE][PowerPoint] Tools for working with Unicode in VBA | reddit.com/r/vba | 2021-05-15
  • GitHub repo 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).

  • GitHub repo 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 2021-12-30.

VBA Vba related posts


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

Project Stars
1 crypto_vba 139
2 VBA-JSON-parser 68
3 VBA-Better-Array 57
4 QRCodeLibVBA 43
5 VBA-CSV-interface 24
7 Export-MS-Project-to-MS-Excel 9
8 VBA-ExtendedDictionary 6
9 ECPTextStream 4
10 geo_vba 4
11 VBAUnicodeTools 3
12 SQLiteC-for-VBA 1
13 excel-formula-print 0
Find remote jobs at our new job board 99remotejobs.com. There are 29 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
OPS - Build and Run Open Source Unikernels
Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.