Great video Spencer, just what I needed. One question, how do you get longitude/latitude to be written in the xx.xxxxx format? I only get the coordinates sown as a number.
HI after 17 addresses the macro stopped working saying ( server limit reached) I have a large list off addresses that need coordinates. What can i do to get around this??
I continuously get, "#NAME?" in the cell that I'm inputting the conversion, I am referencing the correct cell and using the correct format for the address.
Thank you for the video, very informative. Are you familiar with a way to reverse this? Meaning, find the address from coordinates. I know google does it but only for one address at a time.
Hi and sorry for answering instead of the video uploader. Yes, there is a way and it's called reverse geocoding. You can try the code that you will find on this page: www.myengineeringworld.net/2018/03/reverse-geocoding-vba-google-api.html
Ray Hall - Yes, Google puts a daily and per second limit on its Geocoding API. Max 2500 requests per day and 50 per second. developers.google.com/maps/documentation/geocoding/usage-limits
Hi Ray, I'd imagine it is possible - but it's beyond my technical knowhow. As mentioned in the video description, the code was written by Christos Samaras; my VBA knowledge is intermediate at best. I'd suggest reaching out to a VBA expert with practical knowledge of Google API to make that happen.
The particular video uses a VBA function that it was written by me a few years ago. For anyone who is still interested in geocoding from Excel, in the next link, there is the updated version of that function (written in 2018): www.myengineeringworld.net/2014/06/geocoding-using-vba-google-api.html The particular post contains information on how to acquire an API key for free.
Hi All, I am receiving a #VALUE! error message when I attempt to use the GetLat/GetLong functions that were written. Any tips for troubleshooting? Thank you!
Assuming that you already have a valid API key, then check if your address is well-formatted. If the address contains special characters (this quite common in some non-English languages, then the functions might not work. If this is the case, just remove those characters and retry.
Great video Spencer, just what I needed. One question, how do you get longitude/latitude to be written in the xx.xxxxx format? I only get the coordinates sown as a number.
Excellent content - worked like a champion! Thanks.
I can't figure out how to change to Microsoft XML v.3 on Microsoft 2017. Any insights?
Now I want to map out a list of coordinates, overlayed to google earth or something similar? What is the most efficient way to do this?
Or I would prefer map in which I could explore say the topography and environment and get details from each point.
Amazing!!! i am so delighted to land on your video :) cheers
So great! Works a treat for a job I had to do
THANK YOU SO MUCH FOR THIS TUTORIAL !
I was using the program successfully, left then came back to it and now when i try i'm getting NAME? in the field any help please....
GAMECHANGER! Thank you so much
Thanks for sharing great stuff... what is the accuracy of this lat and long data? And from where this data sourced?
What about adding an API Key?
HI after 17 addresses the macro stopped working saying ( server limit reached) I have a large list off addresses that need coordinates. What can i do to get around this??
I continuously get, "#NAME?" in the cell that I'm inputting the conversion, I am referencing the correct cell and using the correct format for the address.
Double click on the =get and then select the cell with the address.
thanks for this, was tremendous help!
Thank you for the video, very informative. Are you familiar with a way to reverse this? Meaning, find the address from coordinates. I know google does it but only for one address at a time.
Hi and sorry for answering instead of the video uploader.
Yes, there is a way and it's called reverse geocoding.
You can try the code that you will find on this page:
www.myengineeringworld.net/2018/03/reverse-geocoding-vba-google-api.html
it works perfect! thank you very much!
This is not working , it returns a error function. will this work is South Africa
value error
thanks man this helps me
thank you so much
Is there a limit to the number of addresses you can do at once?
Ray Hall - Yes, Google puts a daily and per second limit on its Geocoding API. Max 2500 requests per day and 50 per second. developers.google.com/maps/documentation/geocoding/usage-limits
I understand that if you sign up for billing and get an API key, the limit is 100k. Can your code be modified to include your API key?
Hi Ray, I'd imagine it is possible - but it's beyond my technical knowhow. As mentioned in the video description, the code was written by Christos Samaras; my VBA knowledge is intermediate at best. I'd suggest reaching out to a VBA expert with practical knowledge of Google API to make that happen.
The particular video uses a VBA function that it was written by me a few years ago.
For anyone who is still interested in geocoding from Excel, in the next link, there is the updated version of that function (written in 2018):
www.myengineeringworld.net/2014/06/geocoding-using-vba-google-api.html
The particular post contains information on how to acquire an API key for free.
Christos - huge thanks for the update. I've added the link to the updated code in the video description.
Great, thank you!
Hi All, I am receiving a #VALUE! error message when I attempt to use the GetLat/GetLong functions that were written. Any tips for troubleshooting? Thank you!
Assuming that you already have a valid API key, then check if your address is well-formatted. If the address contains special characters (this quite common in some non-English languages, then the functions might not work. If this is the case, just remove those characters and retry.