VBA Excel

Open-source VBA projects categorized as Excel

Top 12 VBA Excel Projects

  • VBA_personal

    Library with VBA, used in multiple projects.

  • 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! | /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

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • Excelerator

    This is an Excel Addin for Windows that reads and writes data to Snowflake

    Project mention: Connect Snowflake with Excel | /r/snowflake | 2022-09-15

    Probably doesn't help, but if you can run Parallels this is a handy Excel add-in for writing and querying data in Snowflake. Only works on Windows. https://github.com/Snowflake-Labs/Excelerator Mac issue: https://github.com/Snowflake-Labs/Excelerator/issues/2

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

  • pacellman

    Pac-Man in Excel

  • 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 | /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 | /r/excel | 2022-09-14
  • 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.

  • VBA-CSV

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

  • geo_vba

    A geographic toolkit/library for VBA, excel etc.

  • SQLiteC-for-VBA

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

  • excel-formula-print

    VBA macro to print formulas with variable names

  • Serial-Ports-in-VBA-Extra-Simple-2022

    Minimal Version

    Project mention: Reading data from a COM PORT (RS232) 64-Bit ? | /r/vba | 2022-09-30
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-20.

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_personal 121
2 VBA-Better-Array 85
3 Excelerator 62
4 Power-Refresh 58
5 pacellman 48
6 VBA-General 44
7 Vincenty-Excel 38
8 VBA-CSV 17
9 geo_vba 5
10 SQLiteC-for-VBA 2
11 excel-formula-print 1
12 Serial-Ports-in-VBA-Extra-Simple-2022 0
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com