Excel 2013 - Bing Map Customization

[bs0d]

Curious if anyone has customized the Bing Map Add-in for Excel 2013?

I'm not finding much information on the net. From my observation, you cannot use VBA to manipulate the map. Instead, I believe JavaScript is used via HTML file (somewhere).

At any rate, here's what I'm looking to do:

• If using Lat/Long as the location, also be able to have a text label for the name (instead of the lat/log numbers).
• If mapping multiple data points, be able to set the focus / default / (select) one of the data points so that the data label is displayed.

Thanks,

 

[bs0d]

Added a trackback URL from Microsoft in case someone there identifies a solution. ( http://answers.microsoft.com/en-us/...-f0ab-4601-a433-4abe5aace300?tm=1396618338467 )

Still testing label options with brute force.

 

[Kyle123]

I very much doubt you can. As I understand it, you've essentially just got a frame embedded in your worksheet that is pointed at a website, you've no more control over the bing maps control than you would on any website (less so in fact). I think you're going to be out of luck here, that said if you know javascript, it shouldn't be too hard to write your own version

 

[bs0d]

I'm sure you're right due to the limited amount of data I have found available.

It seems having the mapping capabilities without the customization is misleading.

But if I understand you correctly, you can write one in JavaScript and embed it into your spreadsheet? Would your items need to be hard-coded or can the JS read the workbook sheet contents? Thanks Kyle123

 

[Kyle123]

Sort of, apps for office are really just websites with a JavaScript API that allows them to interact with the workbook. So you can create your own app fairly easily - it's pretty straightforward, eaxactly what you are wanting to do will dictate how complex your website needs to be, but there are some good tutorials out there to get you started.

 

[bs0d]

Sort of, apps for office are really just websites with a JavaScript API that allows them to interact with the workbook. So you can create your own app fairly easily - it's pretty straightforward, eaxactly what you are wanting to do will dictate how complex your website needs to be, but there are some good tutorials out there to get you started.

Thanks Kyle123

Any chance you could point me towards a few of them? So far I'm just finding articles where people install the bing app in Excel, rather than creating one from scratch. Also, a Google map may be more ideal. Thanks again