Google Map Integration - HELP!

[kgaul01]

Greetings Fellow Excel Nerds,

I am working on a project that requires good map integration. The user will have a csv and an accompanying kml file. The desired result is a map displayed on the worksheet with the ability to click on a given record or set of records and display location points on the map. Can anyone point me in the right direction? Also, this needs to be done via VBA.

 

[Rijnsent]

Hi Kgaul,

a map on a worksheet in Excel probably requires Microsoft PowerMap ( https://support.office.com/en-us/ar...ower-Map-88a28df6-8258-40aa-b5cc-577873fb0f4a ) , this tutorial has some stuff on importing a KML: https://blogs.office.com/2015/05/18/power-map-for-excel-may-update-for-office-365/ . How you could use VBA with Power Map is a bit of a mystery, I tried searching for it but got zero code snipplets, so I don't know how much can be done...

Hope that helps a bit,

Koen

 

[VeryForgetful]

Does it have to be done in Excel? You could do it through Google Maps or Google Fusion Tables which would be easier? If you still need it in excel afterwards you could use the Web Browser Control to show the resultant web link on an a Excel worksheet.

 

[kgaul01]

Unfortunately it does need to be done in Excel and they want to be able to see the map on the sheet with ability to click on a table record and jump to that map location. Ideas?

 

[Rijnsent]

Hi KGaul,
can you tell me a bit more about the KML and CSV? Is the KML every time different? Or is there a big set of regions where the KML will be a selection from? Do you have Power Map in your Excel?
Thanks for helping me to help you ,
Koen