Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Object MS MapPoint
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Object MS MapPoint
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Mappoint on a website | Excel Discussion (Misc queries) | |||
excel and mappoint | Excel Programming | |||
MapPoint Optimization | Excel Discussion (Misc queries) | |||
MapPoint Colors | Excel Programming | |||
Excel and MapPoint | Excel Programming |