Excel 03 and MapPoint Integration

Hi,

I'd like to create a "dynamic" map using MapPoint. I can insert the object, but I can't get any "local" data into the map - I have to import data from another file. I could either push a button to export pre-formatted addresses from excel into a txt file, then import from that (lame...), or I could figure out how to automate the process.

I'd like to embed the map into my template and just have it auto-update a map contained within the same template xls file. The data would have several columns for a label, st #, st name, st suffix, st direction and a number equal to the distance from my first row. My first row would be the "center point" for the map, and the scale for the map would be the max() of all of my subsequent data points, plus 10% or 15%.

All I get right now is =EMBED("MS Mapoint ... ",""), but I'm not sure if "" can be the array of data or something else to automate the process.

If anybody has attempted this, or has a fix, hook a brother up.

Thx in advance