OneDrive Developer Center (redirect)

Looking for the Live SDK?

OneDrive logo

The Live SDK 5.6 is now available

Find it on the OneDrive Dev Center, the new place to find samples, documentation, and other resources for integrating OneDrive into your app.
Choose your download

If you're using previous versions of the Live SDK, the Live SDK 5.5 reference is still available.

 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
OneDrive Developer Center (redirect)

Looking for the Live SDK?

OneDrive logo

The Live SDK 5.6 is now available

Find it on the OneDrive Dev Center, the new place to find samples, documentation, and other resources for integrating OneDrive into your app.
Choose your download

If you're using previous versions of the Live SDK, the Live SDK 5.5 reference is still available.