Has anyone written code to take an address in a spreadsheet and open up Bing Maps or Mapquest to that address? As an example, Outlook has a button called "Map It" that opens up Bing Maps and populates it with the address data. I figure this is some kind of API call but I also know that I am a little out of my depths with figuring that out on my own.
you could use hyperlink to do this, for example a google link would be something like this.
=HYPERLINK("http://maps.google.ca/maps?q="&SUBSTITUTE(A1," ","+"),"Map It")
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
A simple and elegant solution. Thanks!
No problem, glad i could help you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks