I found the below code on this web page http://guj800.wordpress.com/2011/04/...ions-in-excel/ and I can't seem to get it to work. Any suggestions as to why its gives me an error? I did have to download MSINET.OCX file so I would use the Inet reference.

What I am trying to do is have the ability to get driving time from one address to another. I have around 130 different locations that I want to know how far they are for each of my associates. I have around 500 associates, so looking each one up on Google maps would take forever. I did have another worksheet that used another VBA function called "getggoogdistancetime"... which I have seen on a lot of forums, but that seems to no longer work. I've been trying to find something that works. I will list the other code I was using below as well.

This is the new code that I found that I can't get to work. 
Please Login or Register  to view this content.


This is the old code that I found that was working, but now no longer does. 
Please Login or Register  to view this content.