VBA Excel

Open-source VBA projects categorized as Excel
Edit details
Topics: Vba vba-excel CSV Input Geographic
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
Sponsored

Top 13 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

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • Excelerator

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

    Project mention: Tool for Loading Adhoc Excel Files to Warehouse | /r/dataengineering | 2023-07-09

    I found the Excel add-in for Snowflake (https://github.com/Snowflake-Labs/Excelerator) to be performant and useful for ad-hoc files, but it keeps crashing every time there is an update to Excel. It doesn't seem like it is actively maintained. It also lacks any data quality checks and has a clunky interface.

  • Power-Refresh

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

  • pacellman

    Pac-Man in Excel

    Project mention: TIL that nearly 16,000 COVID cases went unreported in England because Public Health England used a legacy .xls Excel spreadsheet file that can only handle up to 65536 rows to record cases instead of a proper database. | /r/todayilearned | 2023-07-13

  • VBA-General

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

  • Vincenty-Excel

    Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • VBA-CSV

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

  • Excel-Pomodoro-Timer

    Excel Pomodoro Timer

    Project mention: Can I use Excel in another window while my workbook with vba is running in background? | /r/vba | 2023-05-22

    I suspect that your reason for asking this is that you've found that getting VBA to run every X minutes (using Application.OnTime?) will throw an error if VBA is already running, or if you're in the middle of editing a cell, etc. One way around this is, as u/e032 and u/Either-Belt-1413 point out, to create a further instance of Excel (InstanceTwo), with the VBA code running in a workbook loaded into that instance. There are a number of projects which demonstrate this - it's a very useful method - but the one that comes immediately to mind (and is most relevant to what you're doing) is the Excel Pomodoro Timer. When it is loaded, it creates a new instance of Excel in the background, and loads a userform with a pomodoro timer on it, which is then displayed at all times on top of any Excel workbook you're using without throwing any of the above errors. There are some much more complex and sophisticated methods using Win32 APIs - like this one - but that may be using a jackhammer to crack a wallnut.

  • 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

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-07-13.

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 134
2 VBA-Better-Array 102
3 Excelerator 73
4 Power-Refresh 67
5 pacellman 50
6 VBA-General 48
7 Vincenty-Excel 44
8 VBA-CSV 19
9 Excel-Pomodoro-Timer 13
10 geo_vba 5
11 SQLiteC-for-VBA 4
12 excel-formula-print 3
13 Serial-Ports-in-VBA-Extra-Simple-2022 1

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com