geo_vba
Power-Refresh
Our great sponsors
| geo_vba | Power-Refresh | |
|---|---|---|
| 3 | 2 | |
| 5 | 67 | |
| - | - | |
| 0.0 | 1.8 | |
| over 3 years ago | about 2 years ago | |
| VBA | VBA | |
| GNU General Public License v3.0 only | MIT License |
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
-
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
Power-Refresh
-
Is it possible to auto-refresh without opening a workbook?
An overkill solution but i think its the best. you can search github for another scripts that either use VBA or powershell or python.
-
Automating Tedious Data Tasks
I came across this resource, which I haven't yet used myself, but seems potentially promising using a combination of some VBA code as well as an open-source scheduler: https://github.com/IvanBond/Power-Refresh/
What are some alternatives?
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
VBA-CSV - Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.
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).
Serial-Ports-in-VBA-Extra-Simple-2022 - Minimal Version
VBA_personal - Library with VBA, used in multiple projects.
Vincenty-Excel - Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
VBA-General - A repository of various modules and classes for interacting with Excel and doing other... things.
VBA-Better-Array - An array class for VBA providing features found in more modern languages
Excelerator - This is an Excel Addin for Windows that reads and writes data to Snowflake