Excel displays the Regression dialog box. When Excel displays the Data Analysis dialog box, select the Regression tool from the Analysis Tools list and then click OK. It will return JSON, that can be parsed to get the nearest available location. Tell Excel that you want to join the big leagues by clicking the Data Analysis command button on the Data tab. It can be achieved using following Google API: Reverse geocoding is the process of taking a set of GPS coordinates and turning it into the nearest available address.īrowsing through the net, I found VBA code on many websites to get GPS coordinates(latitude & longitude) from a location address but found it really hard to get a reverse geocoding in VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |