I completely new to MapPoint so please be patient and let me know if you require any more info. I have embedded a map into Excel and linked two data sets to this map, for ease of use "Dataset1" - pushpins & "Dataset2" - shaded by county. I would like some help in writing the vba code to update the map in line with the data when a macro is run.

I'm struggling even to reference the embedded map within excel at the moment. Any help will be greatly appreciated.