+ Reply to Thread
Results 1 to 6 of 6

Google distance and time

  1. #1
    Registered User
    Join Date
    05-05-2010
    Location
    Maidenhead, England
    MS-Off Ver
    Excel 2007
    Posts
    39

    Google distance and time

    Hi all,

    I wonder if you can help. We were using some fabulous code which I believe was from a user on the forum, but unfortunately it seems excel has changed it web page and the macro no longer works. Would anyone be able to assist to get it working again please? The original code was:

    Please Login or Register  to view this content.
    Many thanks
    Paul

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Google distance and time

    What does "it no longer works" mean?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    12-07-2011
    Location
    Ontario
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Google distance and time

    I am thinking for the same reason mine is no longer working (posted here about 1.5 hours ago)

    I believe they may not getting anything returned from

    TgetGoogDistanceTime = CDbl(Left(TgetGoogDistanceTime, InStr(1, TgetGoogDistanceTime, " ") - 1))

    as it shows me TgetGoogDistanceTime = 'NOT FOUND'

    The same goes with VgetGoogDistanceTime

  4. #4
    Registered User
    Join Date
    12-15-2011
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Google distance and time

    I have the same problem! - I am no expect!

    Can an expect please look into this?

    This might help - LINK

    thanks

    CoL
    Last edited by McGster; 12-15-2011 at 06:32 AM. Reason: Adding Link

  5. #5
    Registered User
    Join Date
    12-15-2011
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Google distance and time

    Kyle123 has fixed this!!! Head over to http://www.excelforum.com/excel-gene...78#post2663778

  6. #6
    Registered User
    Join Date
    05-05-2010
    Location
    Maidenhead, England
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Google distance and time

    Can anyone else assist? Kyle123 has removed his answer due to api terms

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1