Hello. I have read many threads on this site about using Google Maps to calculate the distance in miles between 2 different post codes. I have copied the relevant code but cannot get it to return anything other than a zero.
I want to return in cell C the value of the distance in miles between the post code in cell A and cell B. Any help would be greatly appreciated.
I have attached the workbook in question.
Last edited by smart_as; 07-05-2011 at 11:10 AM.
You might try changing:
to:
Please Login or Register to view this content.
(the above resides in the 3rd Function listed)Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
For that purpose I use:
(with a reference to Microsoft XML library)
Please Login or Register to view this content.
Last edited by snb; 07-02-2011 at 06:22 AM.
@snb, per my earlier post I believe the response string has altered, using "distance:" as search criteria will no longer retrieve the appropriate value.
@DonkeyOte,
You are quite right.
I amended my previous code.
Thank you so much that corrected the problem. I really appreciate this.
Jon
Hello Jon,
I am also looking into this file. Is there a possibility to post on here the working file. The one that has been corrected? I have tried to downoad your earlier version and tried to follow the changes from sbn but could not make it work
Would you be happy to post your working file on here or I can give you an email address?
Thanks for your help Jon
Didier
Hello,
I would also like to see the working version. I have tried to get this thing working for about 2 days now and I am starting to think its not actually possible.
Thanks.
Apparently not possible (Google seems to have a 'always change what works' policy):
NB. you need a reference to Microsoft XML version 2.0Please Login or Register to view this content.
Last edited by snb; 02-07-2012 at 10:21 AM.
Where do I need to add this code?
Whereever you want to as long as it's a codemodule (workbook, sheet, userform, macromodule, classmodule).
I added an attachment to the previous post.
Last edited by snb; 02-07-2012 at 10:22 AM.
Your attachment works perfectly however whenever I try it for one that is in the UK it does not seem to work.
so give me those postcodes and I'll try it over here.
I know it works for Barcelona, Sweden etc.
Need the distance in miles between ss11 8bh & cm11 1hd
So how did you get on, any chance of the working version for all UK post codes?
I'm a basic Excel user. How do I use code above? where do I put?
thanks
Hello all
i know this is a deadpost but can we reopen it.
i think the coding in this workbook is great however i cannot see how it has been resolved.
I am also stuck with a similar position, i do not want to start looking at APIs when it comes to extracting data from googlemaps, i would like to look at other options and this should nail it on the head tbh
Mario
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks