MapForums

mapenthuse · #1 (**permalink**) 02-28-2008

We are having trouble opening our Map Point map from a Word module. when it runs, it opens Map point but not our map. Without the last two lines we get an open Map POint application. When we manually close that we get a debug error on the line that opens our file. With the last two lines (the ones with "nothing"), we just get a blank screen (I assumed the MP program was just open and closed).

Here is our code:

Code:

Public Sub OpenDS1()
    Dim objApp As New MapPoint.Application
    objApp.Visible = True
    objApp.UserControl = True
    objApp.OpenMap objApp.Path + "C:\Documents and Settings\Gary Willick\My Documents\GPS-GIS\wsstores12.17.06.ptm"
 
 
 
    Set objMap = Nothing
    Set objApp = Nothing
End Sub

Thank you,

Gary

**Eric Frost** · #2 (**permalink**) 02-28-2008

I made a couple changes, try this code:

Code:

Public Sub OpenDS1()
    Dim objApp As New MapPoint.Application
    objApp.Visible = True
    objApp.UserControl = True
    objApp.OpenMap "C:\Documents and Settings\Gary Willick\My Documents\GPS-GIS\wsstores12.17.06.ptm"
 
 End Sub

mapenthuse · #3 (**permalink**) 03-05-2008

Eric - Thanks - it worked! on to the next phase.

I will be searching for all stores in a given zip code. Do I have to loop through the entire data set, find all those with the desired zip, and put each one in a push pin set? I then want a route calculated that hops from one store to the next, starting from my source address. Can map POint calculate the best order for this route, or is it done in the order they were found? If the latter, is there some way for me to view the found set of push pins and set an order before driving directions are actually calculated?

GAry

**Eric Frost** · #4 (**permalink**) 03-06-2008

Good! thanks for following up.

Good luck with the next phases. If you get stuck on any part, feel free to pop in here and show the code and it would probably help to post your ptm and any other information.

Try to keep it to one question per post, I'll take a stab at answering your questions now.

Quote:

I will be searching for all stores in a given zip code. Do I have to loop through the entire data set, find all those with the desired zip, and put each one in a push pin set?

It might be easier to export them all using a right-click "Export to Excel" and then look in the Excel spreadsheet.

Quote:

I then want a route calculated that hops from one store to the next, starting from my source address. Can map POint calculate the best order for this route, or is it done in the order they were found?

Yes! see the Help File in the Optimize method.

Quote:

If the latter, is there some way for me to view the found set of push pins and set an order before driving directions are actually calculated?

How do you want to view them? Maybe have a step that dumps them out to Excel and then re-imports after you make adjustments?

Eric

mapenthuse · #5 (**permalink**) 03-06-2008

I don't need to export to Excel if teh data was originally there. I can just query excel, import into MP, then have MP calculate the route. I will look at teh optimize function in Help.

I assume I can do all this in code?

GAry

**Eric Frost** · #6 (**permalink**) 03-06-2008

I think it can all be done in code..

Eric

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/problem-opening-map-7192.html
Posted By	For	Type	Date
Extracting the Mappoint 2002 Points of Interest - MapPoint Articles - MP2K Magazine	This thread	Refback	02-28-2008 11:47 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening VBA editor for mappoint	Brock	MapPoint 2006/2009 Discussion	2	01-15-2007 08:06 AM
MapPoint C# Job Opening	Eric Frost	News and Announcements	0	12-17-2006 08:30 AM
MapPoint "There was a problem opening ..." With Or	eric.hill	MapPoint 2006/2009 Discussion	2	04-03-2006 08:48 PM
Opening a 2000 file	FDPoint	MapPoint 2006/2009 Discussion	0	06-03-2004 06:35 AM
Opening a new map takes about 10 sec ?!?!?!	Anonymous	MapPoint 2006/2009 Discussion	1	07-25-2002 12:43 PM

MapForums

Problem opening map

Problem opening map

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/problem-opening-map-7192.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

Problem opening map

Problem opening map

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/problem-opening-map-7192.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/problem-opening-map-7192.html