SaaSHub helps you find the best software and product alternatives Learn more →
Top 12 VBA Excel Projects
Library with VBA, used in multiple projects.
An array class for VBA providing features found in more modern languagesProject 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
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.
This is an Excel Addin for Windows that reads and writes data to SnowflakeProject 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
Schedule refresh of any Excel file using open-source scheduler & refresher written on VBAProject 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.
Pac-Man in Excel
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.
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
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.
Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.
A geographic toolkit/library for VBA, excel etc.
SQLite library for VBA wrapping ADODB and SQLite C-language API.
VBA macro to print formulas with variable names
Minimal VersionProject mention: Reading data from a COM PORT (RS232) 64-Bit ? | /r/vba | 2022-09-30
VBA Excel related posts
Where/How do you take track of notes
1 project | /r/vba | 16 Dec 2022
VBA Username and Password Regex (MS Access)
1 project | /r/visualbasic | 2 Dec 2022
[OUTLOOK/EXCEL/WORD] Easy way to add Context Menus/Right-Click Menus to VBA UserForms
1 project | /r/vba | 2 Oct 2022
Connect Snowflake with Excel
1 project | /r/snowflake | 15 Sep 2022
Faster to use Excel's Sort or write a custom sort in VBA?
1 project | /r/vba | 2 Sep 2022
Is it possible to auto-refresh without opening a workbook?
1 project | /r/excel | 20 Aug 2022
VBA like a proper dev?
7 projects | /r/vba | 5 May 2022
A note from our sponsor - #<SponsorshipServiceOld:0x00007f0922f428b0>
www.saashub.com | 10 Jun 2023
What are some of the best open-source Excel projects in VBA? This list will help you: