Top 5 VBA Excel Projects
-
u/senipah has done a lot of work extending VBA's array capabilities here. I would look into this to sort your data in memory rather than reinventing the wheel.
-
-
-
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: Can I Create a Heat Map with Excel Data for a Downtown Area? | reddit.com/r/excel | 2021-07-14
As u/Grey_Patagonia_Vest describes: you could add some more information like a postal code to the address. If you're looking for "main street", that will give tons of hits, if you add a postal code and/or city there is a higher chance you get to your desired location/city. I've built this toolkit, based on OpenStreetMap / Nominatim to transform addresses to lat/long -> https://github.com/krijnsent/geo_vba , using the geo_nom_search function, you could give it a try.
-
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
- 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?
- How to structure my program when I want to carry out multiple actions to a range which changes
- Using Variant to make code more universal
Index
What are some of the best open-source Excel projects in VBA? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | VBA-Better-Array | 54 |
| 2 | pacellman | 34 |
| 3 | Export-MS-Project-to-MS-Excel | 9 |
| 4 | geo_vba | 2 |
| 5 | excel-formula-print | 0 |
Are you hiring? Post a new remote job listing for free.
