I use the following code to place pushpins on a map and zoom in the area.
Do Until oWorksheet2.Cells(i, 1) = 0
sStation = oWorksheet2.Cells(i, 1)
Set oStation = oMap.FindResults(sStation).Item(1)
i = i + 1
I also use the code http://www.mp2kmag.com/a13--kohl.extract.lat.lon.mappoint.html to find latitude and longitude of each pushpin. However, I also need to know what is the latitude and longitude of each corner of my map. How can I do that with VBA code.
Thanks for help
p.s: I am a french Canadian. I am sorry for all possible English mistakes.