locked
Open Bing Map with multiple pushpins from VBA code in MS Access

    Question

  • I can currently open a Bing Map for one addess using the following code:

    Application.FollowHyperlink "http://maps.live.com/default.aspx?where1=" & strAddress

    where strAdress contains an addess (street,city state, zip)

    I want to be able to open a similiar map but with pushpins for multiple address.

    Friday, January 29, 2010 11:06 PM

Answers

  • This shouldn't be done as the query string will change over time. I normally have my map defaulted to the beta version on http://maps.live.com and using a query string in the form you suggest doesn't work. You should look at either creating a custom mapping application where you can geocode the locations using Bing Maps and then create a map. Alternatively you can geocode your locations a head of time and use embedded maps which will be really easy to integrate into your existing pages.
    Windows Live Developer MVP - http://rbrundritt.spaces.live.com
    Monday, February 01, 2010 6:12 PM

All replies

  • This shouldn't be done as the query string will change over time. I normally have my map defaulted to the beta version on http://maps.live.com and using a query string in the form you suggest doesn't work. You should look at either creating a custom mapping application where you can geocode the locations using Bing Maps and then create a map. Alternatively you can geocode your locations a head of time and use embedded maps which will be really easy to integrate into your existing pages.
    Windows Live Developer MVP - http://rbrundritt.spaces.live.com
    Monday, February 01, 2010 6:12 PM
  • Mr. MVP Brundritt's prior post seems a bit condescending in his contention that this shouldn't be done.  Perhaps he did not comprehend the simplicity of the original request? 

    I too want to generate a url and launch it via browser from Excel VBA to display a map containing up to 10 pushpins.  I already have the locations geocoded and have successfully generated KML which can be passed to a Google Earth client session.  Since the street map layers in Google Earth are not as clear and crisp as in Google Maps or Bing Maps, I want to generate the same pushpin map and auto-launch Google Maps or Bing Maps instead.  I don't need to create a server-based web page for third party folks to interact with.  All I need to do is pop up the pushpin map based on data within the local system, so a person can look at it momentarily and then close it.

    I suspect the answer lies in generating a url and then launching a browser to render it, but if it requires generating an html page with javascript I can do that too.  I just need basic instructions and a sample of a url or html page that does this.

    It seems this should be pretty simple.  Thanks for any replies.

    Friday, August 13, 2010 6:47 PM