A VBA (Visual Basic for Applications) application for geocoding and reverse geocoding in Excel. Supports both Google's free and enterprise for business geocoder (Google Maps APIs for Business, Google Maps for Work or Google Maps).
Please note : The Google Maps Platform Premium Plan is no longer available for sign up or new customers since November 1, 2018.
Released as a standalone from the [FineDustMonitorWithGPS] project.
Performance improvements (up to 2× as faster than before) in the ADDRGEOCODE function.
Now supports Unicode using Microsoft ActiveX Data Objects Library in the ADDRGEOCODE function.
Added GEOSage sample files.
GEOSage sample includes Excel files that use demonstation data using Google Maps Geocoding API Key. The API key used in this project for geocoding and reverse geocoding feature is not provided for your use. The mock data demonstrates all functions with static result values as Google Maps geocoding API Key and VBA Add-in code are not included in the GEOSage sample.
Added GEOSage.bas file to support directly import from Microsoft Excel.
- Enable [Developer] tab in Microsoft Excel.
- Within the [Visual Basic] IDE, add "Microsoft XML, v6.0", "Microsoft ActiveX Data Objects 6.1 Library" both as References. Could be found within [Tools] - [References].
Takes in the address of the location we want to geocode and returns the first latitude, longitude pair from GEOSage.
Takes in a latitude, longitude pair and returns the first formatted address from GEOSage.
- Functionality for ArcGIS, Bing Maps, Data Science Toolkit etc.
Copyright ⓒ HappyBono 2020 - 2022. All rights Reserved.
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.