this an example of starting map point at a location. you have to look at
mappoint object model to get it to do what you want.

Set mapp = CreateObject("MapPoint.Application")
mapp.WindowState = 0
Set mmap = mapp.ActiveMap
mmap.FindAddressResults("1 Main st", "Hometown", , "CA",
"91111").Item(1).Goto
mapp.Visible = True

"Mike" wrote in message
...
| Hello,
|
| I frequently create ad hoc addresses within Excel with the intention of
| mapping these location within MS MapPoint.
|
| I figured I could automate this is I use the Create Object technique for
| MapPoint. Has anyone ever done this before?
|
| Once the object has been created, I want to pass a selected range of
| addresses to the MapPoint object for plotting.
|
| Thanks for the help.
|
| Mike