Integrating Google Maps into MS Excel

[BramWeeda]

Dear all,

On the internet i've found an excelsheet which integrates google maps with MS Excel (I've added the sheet).
For what i want to do it is almost perfect..almost. When you enter an adress and cityname and click the ''build map'' button your requested city will be found on the map and be marked with a red balloon.
That is just what i need since i need to locate a lot of places. Only thing is that i would like to change the kind of marker that appears (so place one is a red balloon and place two will be a blue balloon, or something like that. In the browser version of google maps it is possible to use different kind of markers and different kind of colours.
The browser version of google maps is not suitable for what i want to do because the city and street names will be generated from other excel tabs in the future. Thats why the google maps integrated into MS Excel is a perfect solution. If i only could change the kind and colour of the markers.
Since im an absolute newbie at MS Excel i dont know how to do this.
I hope you understand what im trying to say and that anyone around here can help me with it!

Thanks in advance,

Bram

EDIT:

Short version, it would be very nice if you have all the functions that the browser-version of google maps has (Like changing the type of markers, colours, pulling lines etc.).

[Leith Ross]

Hello Bram,

Welcome to the Forum!

The code used accesses the API (Application Programming Interface) provided by BatchGeo. This is a simplified version of the Google maps API. It's meant for creating basic maps easily with just HTML or some JavaScript. The BatchGeo API is a JavaScript library for giving addresses and major landmarks. It is does not provide full mapping features like a plug-in would. However, it states that you can "easily add your own custom marker images".This requires using either HTML or JavaScript to pull in the custom images. Unfortunately, there is no option for changing the color of the balloons.

[pike]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this