MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




open a map from Excel

This is a discussion on open a map from Excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I've been following the example in the Help menu, but am still having difficulty... Am writing an Excel macro, to ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack (5) Thread Tools Display Modes
  5 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-21-2007
Junior Member
Yellow Belt
 
Join Date: Mar 2007
Posts: 16
open a map from Excel

I've been following the example in the Help menu, but am still having difficulty...

Am writing an Excel macro, to open a MapPoint 2004 map:

Set mpApp = New MapPoint.Application
mpApp.Visible = True
mpApp.UserControl = True
mpApp.OpenMap mpApp.Path + ("C:\Documents and Settings\A Kolos\My Documents\Excel Mappoint\LHIN.ptm")

(just like in the example), although syntax asks for:
object.OpenMap(Filename, [AddToRecentFiles])
but I keep getting an error message that says the file can't be found...

any thoughts?
thanks,
andriy
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 03-21-2007
Senior Member
Green Belt
 
Join Date: Sep 2005
Location: Marshall, Michigan
Posts: 126
Re: open a map from Excel

The line

mpApp.OpenMap mpApp.Path + ("C:\Documents and Settings\A Kolos\My Documents\Excel Mappoint\LHIN.ptm")

specifies an invalid path. Try removing the "mpApp.Path + " from that line.

-Paul
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 03-22-2007
Junior Member
White Belt
 
Join Date: Mar 2007
Location: Nashua, MT
Posts: 1
Re: open a map from Excel

Can you show the code on that for Streets & Trips?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 03-22-2007
Senior Member
Green Belt
 
Join Date: Sep 2005
Location: Marshall, Michigan
Posts: 126
Re: open a map from Excel

Streets&Trips does not have a programmable interface.

-Paul
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 08-14-2007
Junior Member
White Belt
 
Join Date: Aug 2007
Posts: 5
Re: open a map from Excel

I know it is a purely newbie - silly question but can anyone post the proper code to open an existing map please?

I must say I'm a bit lost with the "objmap", "objapp", "oapp" etc. codes & don't know what the "object" should be before "Open.map ("path")
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 08-18-2007
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,122
Re: open a map from Excel

Hi,

Maybe this will get you started: What's New at MP2K Magazine - The Magazine for MapPoint
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
excel, map, open


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/open-map-excel-5764.html

Posted By For Type Date
Working With Excel and MapPoint - MP2K Magazine This thread Refback 03-29-2007 06:21 AM
MP2K Update Archives - MP2K Magazine This thread Refback 03-28-2007 10:55 AM
MapPoint User Community - MP2K Magazine This thread Refback 03-27-2007 07:18 AM
MapPoint Download - MP2K Magazine This thread Refback 03-26-2007 04:33 PM
The Magazine for MapPoint - MP2K Magazine This thread Refback 03-23-2007 10:54 AM

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

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Problem to open Excel file Chiara MapPoint 2006/2009 Discussion 2 07-19-2006 07:54 AM
Save maps and Open them Steven MapPoint 2006/2009 Discussion 1 05-10-2006 09:19 AM
Open Map Speed Yazzy MapPoint 2006/2009 Discussion 1 06-27-2005 11:52 AM
How do you open a mapoint map in delphi? Anonymous MapPoint 2006/2009 Discussion 5 12-04-2002 08:07 PM
Open all pushpins balloons at once? Anonymous MapPoint 2006/2009 Discussion 9 09-25-2002 10:43 AM


All times are GMT -5. The time now is 10:49 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54