geo_vba
A geographic toolkit/library for VBA, excel etc. (by krijnsent)
VBA-JSON-parser
Backus-Naur Form JSON Parser based on RegEx for VBA (by omegastripes)
| geo_vba | VBA-JSON-parser | |
|---|---|---|
| 3 | 2 | |
| 5 | 105 | |
| - | - | |
| 0.0 | 0.0 | |
| over 3 years ago | over 1 year ago | |
| VBA | VBA | |
| GNU General Public License v3.0 only | GNU General Public License v3.0 only |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
geo_vba
Posts with mentions or reviews of geo_vba.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-04-20.
-
I have 400 locations in Excel; how can I easily add their addresses into the same sheet?
Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba
-
Can I Create a Heat Map with Excel Data for a Downtown Area?
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.
-
Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles)
Not sure if it is of any use to you, but OSM has quite some data too. I have some code in a repository that could be of assistance: https://github.com/krijnsent/geo_vba
VBA-JSON-parser
Posts with mentions or reviews of VBA-JSON-parser.
We have used some of these posts to build our list of alternatives
and similar projects.
-
Accounting software glitch leads to using old/incorrect fx rates in invoices
Downloaded and imported VBA-JSON-parser
-
Extract data from a blob of text
Have you tried VBA JSON Parser?
What are some alternatives?
When comparing geo_vba and VBA-JSON-parser you can also consider the following projects:
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
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).
VBA-Better-Array - An array class for VBA providing features found in more modern languages
Power-Refresh - Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.