Open-source VBA projects categorized as Vba | Edit details

Top 11 VBA Vba Projects

  • GitHub repo crypto_vba

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

    Project mention: Self made Excel/VBA triggers virus scan - what to do? | reddit.com/r/vba | 2021-03-19

    I've built an open source VBA-Excel library to communicate with cryptocurrency exchanges ( https://github.com/krijnsent/crypto_vba ) and have my code available as .bas and in an .xlsm file. A couple of days ago someone posted an issue that my xlsm file triggered a Windows defender alert. At my pc this doesn't happen, the AVG virus scanner also won't show anything.

  • GitHub repo VBA-JSON-parser

    Backus-Naur Form JSON Parser based on RegEx for VBA

    Project mention: Extract data from a blob of text | reddit.com/r/excel | 2021-08-12

    Have you tried VBA JSON Parser?

  • Scout APM

    Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.

  • 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 RFC-4180 compliant and unix style CSV parser library for VBA.

    Project mention: VBA Import of CSV to Excel Sheet | reddit.com/r/excel | 2021-11-15

    Use VBA CSV interface. The DumToSheet method can do the work. Here an example:

  • 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

  • GitHub repo VBA-ExtendedDictionary

    Dictionary object that extends the Scripting.Dictionary

    Project mention: excel - pasting from dictionary into sheet1 | reddit.com/r/vba | 2021-08-14

    Using u/chunkyasparagus' example values, I populated my cExtendedDictionary and dumped it to the sheet. Took at a guess, nearly a second to run.

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

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

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 133
2 VBA-JSON-parser 66
3 VBA-Better-Array 54
4 QRCodeLibVBA 39
5 VBA-CSV-interface 21
6 Export-MS-Project-to-MS-Excel 9
7 VBA-ExtendedDictionary 6
8 ECPTextStream 4
9 VBAUnicodeTools 3
10 geo_vba 2
11 excel-formula-print 0
Find remote jobs at our new job board 99remotejobs.com. There are 35 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