Community of VE/MapPoint Users and Developers
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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| open a map from Excel 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 |
| |||
| 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 |
| |||
| Re: open a map from Excel
Streets&Trips does not have a programmable interface. -Paul |
| |||
| 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") |
| |||
| Re: open a map from Excel
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
![]() |
| Tags |
| excel, map, open |
| ||||
| 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 | |
| |
| ||||
| 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 |