Top 9 VBA Excel Projects
-
Senipah's Better array
-
Excelerator
This is an Excel Addin for Windows that reads and writes data to Snowflake (by Snowflake-Labs)
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
-
SonarLint
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.
-
-
VBA-General
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-18What are you doing with this project overall? (Also you can view more of where those functions came from here)
-
Export-MS-Project-to-MS-Excel
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).
If needed, you may use: https://github.com/PopovGP/Export-MS-Project-to-MS-Excel
-
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.
-
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
-
Scout APM
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.
-
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).
-
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?
- I have 400 locations in Excel; how can I easily add their addresses into the same sheet?
- General Git repo with vba code
- Filling combobox and sorting it
- Can I Create a Heat Map with Excel Data for a Downtown Area?
- Good general Mechanic Calculation Suite?
- What is the best way to import a CSV as a 2D array in Word?
Index
What are some of the best open-source Excel projects in VBA? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | VBA-Better-Array | 68 |
| 2 | Excelerator | 39 |
| 3 | pacellman | 37 |
| 4 | VBA-General | 36 |
| 5 | Export-MS-Project-to-MS-Excel | 13 |
| 6 | VBA-CSV | 10 |
| 7 | geo_vba | 4 |
| 8 | SQLiteC-for-VBA | 1 |
| 9 | excel-formula-print | 0 |
Are you hiring? Post a new remote job listing for free.
