+ Reply to Thread
Results 1 to 11 of 11

VBA Formula to Calculate Distances with Google Maps API BROKEN

  1. 08-09-2018, 12:26 PM #1
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    VBA Formula to Calculate Distances with Google Maps API BROKEN

    A very wonderful coder: Desmond Oshiwambo put a little diddly together several years ago that saved me literally thousands of hours of manual entry.

    I was just using it yesterday and all was fine....... Today 8/9/2018 it has just stopped working. It is clearly trying to connect but does not return the information back like is has done for years.

    I am hopeful there is an issue with google today and that the issue will resolve itself, but I am a glass is 1/2 empty kinda guy so I am asking if anyone knows what is aims?

    Below is the code for the macro, you can even download a copy to see what I mean about it no loner working.

    Any help would be very much appreciated.

    -Ken


    https://desmondoshiwambo.wordpress.c...stance-in-vba/
    Reply With QuoteRegister To Reply
  2. 08-09-2018, 12:30 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,800

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    There have been changes to the Google Maps API and what is and isn't free.

    You might find these links useful:

    https://cloud.google.com/maps-platform/user-guide/

    https://developers.google.com/maps/b...ortant-updates
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-09-2018, 12:37 PM #3
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    Ok- i don't mind paying for this at all, i just have no idea of where to enter my API key into the code that Desmond has written as I am not a coder.
    Reply With QuoteRegister To Reply
  4. 08-09-2018, 12:38 PM #4
    danielexcelvba
    danielexcelvba is offline
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    Looks like the link you said has the instructions on how to update the code to include an API key - have you tried that?
    Reply With QuoteRegister To Reply
  5. 08-09-2018, 12:39 PM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,800

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    I posted because I thought that it might not be working for you if you have not yet given Google your credit card number. If you have, then fine.

    It might be helpful to copy the code you are using to your next post and wrap it in code tags. That way helpers don't have to follow links unnecessarily.
    Reply With QuoteRegister To Reply
  6. 08-09-2018, 12:41 PM #6
    Zer0Cool
    Zer0Cool is offline
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    Google used to allow people in Excel/VBA to grab translations (via Google Translate) for words. I once created a spreadsheet to not only translate a word in like 50 languages (everyone offered by Google Translate at the time) but to play the pronunciation of the word in that language when clicking on the cell with the translated word.

    While I was working on it Google altered their policies to prevent this and required people to use their API for translate and there was no free option.

    I think they have a habit of changing to paid API's once they realize there is an interest in them.

    I cant say for sure about Google Maps API use in VBA, but I would imagine its a popular API and that Google could feasibly have altered their stance on offering it for free.

    EDIT: If your paying Google, shouldnt they offer some kind of support for it? You may consider contacting them.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me
    Reply With QuoteRegister To Reply
  7. 08-09-2018, 12:58 PM #7
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    I am a moron. I did not see that. He does say its free, however it does not look to be the case.
    Reply With QuoteRegister To Reply
  8. 08-09-2018, 12:59 PM #8
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    I am going to ask my boss to create a key for the company, it does not seem fair that i should be responsible for paying a bill right?
    Reply With QuoteRegister To Reply
  9. 08-09-2018, 01:14 PM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,800

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    I think the thing is that small usage WILL be free, however you can't have that usage without someone lodging a credit card number with Google. So, whilst you may not end up paying anything, no, it should absolutely not be your personal credit card that is used for this. The API needs to be in the name of the company and paid for using a company card.
    Reply With QuoteRegister To Reply
  10. 08-09-2018, 01:33 PM #10
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    Well the company is already using google email services so i assume they have a credit card on file already. it just says that i do not have access to the Keyid information. So i guess i am on the right track anyway no?
    Reply With QuoteRegister To Reply
  11. 08-09-2018, 01:43 PM #11
    dominicb
    dominicb is offline
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: VBA Formula to Calculate Distances with Google Maps API BROKEN

    Good evening sungen99

    Forum Guru Kyle123 put something together a while ago and posted it on this forum, and updated it at the end of May this year. His offering will work with Google and Microsoft's equivalent, which I believe is free, but you need to register for. You might want to try looking at his work, here : https://www.excelforum.com/tips-and-...rivetimes.html

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating Google Maps Distances Using Postcodes
    By smart_as in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-14-2021, 03:08 PM
  2. VBA Formula to Calculate Distances with Google Maps API
    By Tonan230 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2015, 07:25 PM
  3. Using google to calculate distances… in a macro
    By fosters_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2014, 03:37 PM
  4. Broken Formula to Hyperlink longitude and latitude cells to google maps
    By Nola ADA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 09:48 AM
  5. Calculate Distance using Google Maps
    By excelinexcel7 in forum Excel General
    Replies: 2
    Last Post: 12-06-2012, 06:19 PM
  6. Returning Distances From Google Maps
    By lauzhang in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2012, 10:00 AM
  7. Parsing Google to calculate driving distances for addresses
    By tomn13 in forum Excel General
    Replies: 1
    Last Post: 12-15-2011, 10:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1