Excel Code to Send Info to MapQuest or Google Maps

[oneal1767]

I'm trying to figure out if there is a way to write a code so if in column A I have a list of City, State going down 20 or so rows and each being a different location to send this to MapQuest or Google Maps so that it saves each location to a map for viewing. I do this daily with my job on mapquest, but have to go in manually, search, and then save to a map name I have saved under my maps. If this could be done it would save me a ton of time. When finished, I need to be able to look at the map and see the pushpin or bubble for each saved location. I just don't know where to start, but would appreciate any help!

Thanks!

[brucemcpherson]

This certainly possible using any of the major mapping Apis. You can download an example of how to use all of them .. It includes a finished app you can use as is.. Directly from excel.

See http://ramblings.mcpher.com/Home/excelquirks/getmaps
Bruce

[Oliverjones]

Hi oneal1767, I am not sure if you have resolved this as yet but we have recently gone live with the MapCite Excel Mapping tool, available as a free download:

http://www.mapcite.com/excel-trial.aspx

Nice write up by Bing Mapping Guru is here:

http://rbrundritt.wordpress.com/2011...s-excel-addin/

Oliver