SaaSHub helps you find the best software and product alternatives Learn more →
Top 12 VBA Excel Projects
-
-
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.
-
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
An overkill solution but i think its the best. you can search github for another scripts that either use VBA or powershell or python.
-
-
VBA-General
A repository of various modules and classes for interacting with Excel and doing other... things.
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).
-
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 Excel related posts
- Where/How do you take track of notes
- VBA Username and Password Regex (MS Access)
- [OUTLOOK/EXCEL/WORD] Easy way to add Context Menus/Right-Click Menus to VBA UserForms
- Connect Snowflake with Excel
- Faster to use Excel's Sort or write a custom sort in VBA?
- Is it possible to auto-refresh without opening a workbook?
- VBA like a proper dev?
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007f0922f428b0>
www.saashub.com | 10 Jun 2023
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 |