Hi Steve,

Steve E wrote:
Very slick. I'd figured out how to pass the address info out to
mapquest using the hyperlink worksheet function but had no idea where
to even start getting the driving distance back out... I clearly will
not be leaving my day job anytime soon...

Glad you liked it. I would not use something like this in a production
environment for a few reasons: 1) it's wholly dependent on the mapquest
website - any changes to the form or results page, and it likely won't work,
2) there's no error handling, and 3) there's no way to communicate to the
user that mapquest needs some clarification - it just fails if the user's
address doesn't match exactly what mapquest is expecting. But it's a fun
excercise. <g

If you want something more robust, most mapping systems provide some type of
API that you can hit with your code. Here's a link to mapquest's:

http://www.mapquest.com/features/mai...per_tools_oapi

Thanks a million!

You're very welcome!

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]