Google Maps - Distance Calculator

[attaul]

Hi

I am trying to make this work
http://www.excelforum.com/excel-prog...alculator.html

if I run it as it is here
http://www.excelforum.com/attachment...gle-snb-2.xlsm

I get a compile error. First at c01 and c02 (I assume the code does not declare the variables) after declaring the variables with DIM I get an error with this line
With New XMLHTTPRequest

are there steps I need to take before running this?

Thanks,
At

[Bernie Deitrick]

Try it using this, which worked in your workbook.

http://desmondoshiwambo.wordpress.co...stance-in-vba/

[attaul]

I am trying to avoid using the API and use XML on google maps