I have a worksheet named Miles. I also have a Userform that asks the user
for Start Location and End Location then what i want it to do is have it
query google maps (or any other program/process that will do this) for
specific miles and import that finding into cell C2
then if they press New Location (Commandbutton1) it resets the form and puts
the new data in C3. But if they press Done it ends the Macro.

Any Idea how to do that?

Thank you!
Alex

Some flavours of Excel can consume XML web services directly so that would be
the way forward. I don't know if google maps would present the SOAP
formatted web service for direct use as I've not tried, but I'd expect
Windows Live Maps would probably allow you to do that.

Alternatively you can do something similar by automating a local application
like MS MapPoint or possibly autoroute.



"Ewing25" wrote:


I have a worksheet named Miles. I also have a Userform that asks the user
for Start Location and End Location then what i want it to do is have it
query google maps (or any other program/process that will do this) for
specific miles and import that finding into cell C2
then if they press New Location (Commandbutton1) it resets the form and puts
the new data in C3. But if they press Done it ends the Macro.

Any Idea how to do that?

Thank you!
Alex