Top 9 VBA Excel Projects
An array class for VBA providing features found in more modern languagesProject mention: VBA like a proper dev? | reddit.com/r/vba | 2022-05-05
Senipah's Better array
This is an Excel Addin for Windows that reads and writes data to Snowflake (by Snowflake-Labs)Project mention: Power Query in Excel connecting to Snowflake | reddit.com/r/snowflake | 2022-04-24
Not directly applicable but may be relevant at some point if using excel frequently - the excelerator add in. I believe it was developed by snowflake professional services, but important to note not an official product of snowflake themselves. https://github.com/Snowflake-Labs/Excelerator
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
Pac-Man in Excel
A repository of various modules and classes for interacting with Excel and doing other... things.Project mention: (VBA) Starting at B4 I want to count how many cells in row 4 until the cell saying "Grand Total" is reached. | reddit.com/r/excel | 2022-03-18
What are you doing with this project overall? (Also you can view more of where those functions came from here)
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
Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.Project mention: A new year, a new tool to work with CSV files. Happy holidays! | reddit.com/r/vba | 2021-12-23
I tried VBA-CSV, but I guess there is some Excel/Office specific code in there.
A geographic toolkit/library for VBA, excel etc.Project mention: I have 400 locations in Excel; how can I easily add their addresses into the same sheet? | reddit.com/r/excel | 2022-02-24
Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
SQLite library for VBA wrapping ADODB and SQLite C-language API.Project mention: [EXCEL] SQLite C/ADO VBA library with reflection | reddit.com/r/vba | 2021-12-13
Complete project source code with dependencies is available from the GitHub repo and the project documentation - from the GitHub pages site. I perform unit testing under x32/VBA6 (Excel XP/2002 SP3) and x64/VBA7 (Excel 2016) environments. With the entire repository cloned on Windows 10 and the two dependencies (the SQLiteODBC driver and the RubberDuck VBA add-in) installed, the following two quick checks can be executed right away from the immediate pane. This command ?LiteMan(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version used by the SQLiteODBC driver (usually embedded), e.g., 3.23.3, and this command ?SQLiteC("").CreateConnection(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version loaded by the project, e.g., 3.37.0. The project also includes a set of examples, which should also run out-of-the-box (see documentation).
VBA macro to print formulas with variable namesProject 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.
VBA Excel related posts
VBA like a proper dev?
7 projects | reddit.com/r/vba | 5 May 2022
I have 400 locations in Excel; how can I easily add their addresses into the same sheet?
1 project | reddit.com/r/excel | 24 Feb 2022
General Git repo with vba code
2 projects | reddit.com/r/vba | 15 Sep 2021
Filling combobox and sorting it
1 project | reddit.com/r/vba | 25 Aug 2021
Can I Create a Heat Map with Excel Data for a Downtown Area?
1 project | reddit.com/r/excel | 14 Jul 2021
Good general Mechanic Calculation Suite?
1 project | reddit.com/r/engineering | 9 Jun 2021
What is the best way to import a CSV as a 2D array in Word?
1 project | reddit.com/r/vba | 23 Mar 2021
What are some of the best open-source Excel projects in VBA? This list will help you:
Are you hiring? Post a new remote job listing for free.