Distance between Zip Codes - Excel on a Mac

[KLondon]

I'm trying to find a way to calculate the distance between original zipcode in Column A and destination zipcode in Column B.

I've been following other threads that appear to have solved this, however it appears to work on a Windows machine and not a mac.

I am unable to change the reference to the XML file that's being referenced.

Does anyone know of a solution that exists or that can provide some guidance that will work when using excel on a mac?

I'm a complete newbie at VBA by the way

 

[rpaulson]

I use this one:

https://desmondoshiwambo.wordpress.com/2013/06/20/how-to-get-google-travel-time-and-distance-in-vba/

 

[KLondon]

I use this one:

https://desmondoshiwambo.wordpress.com/2013/06/20/how-to-get-google-travel-time-and-distance-in-vba/

Thank you, I inserted the code into Module 1 under my current document but see the following errors:

[FONT=&quot]getGoogleMileage(A2,B2) it says #Name ?
[/FONT][FONT=&quot]getGoogleTravelTime(A2,B2) is says ActiveX Component can't create object[/FONT]

Any clues on what causes these errors and where I should be looking to attempt to fix?

 

[rpaulson]

I did not write it, I just downloaded one of the samples and used it. I'm on a PC not a MAC.