MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Update MP 2004->2006 // Now Problems with VBA-Excel-Makros... 50miles/100miles...

This is a discussion on Update MP 2004->2006 // Now Problems with VBA-Excel-Makros... 50miles/100miles... within the Development forums, part of the MapPoint 2006/2009 Discussion category; Hello, sorry about my english, it isn't good. I'm from germany. I installed both programs, Mappoint 2004 AND 2006. I ...


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

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



Click here to register

Reply

 

LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 06-19-2008
Junior Member
White Belt
 
Join Date: Feb 2008
Posts: 2
Update MP 2004->2006 // Now Problems with VBA-Excel-Makros... 50miles/100miles...

Hello,

sorry about my english, it isn't good. I'm from germany.

I installed both programs, Mappoint 2004 AND 2006. I need it.
All my macros works perfect under Mappoint2004.

Now, with 2006, i want the new feature to calculate until 100 miles.

Look at the code for MP2004, please:

Private Sub CommandButton1_Click()
Dim objApp As New MapPoint.Application
Dim objmap As MapPoint.Map
Dim objloc As MapPoint.Location
Dim Y As String

Set objmap = objApp.ActiveMap
objApp.OpenMap "c:\test.ptm"
objApp.Visible = False
objApp.UserControl = True

Set objloc = objmap.FindAddressResults(strasse1, ort1, , , plz1, "Germany").Item(1)

For x = 1 To 200
Y = Worksheets("Eingabe").Cells(5, 1)
Ergebnis = objloc.FindNearby(Y).Item(x).Name
Next x

objApp.Quit
End Sub

Over 50 Miles, Mappoint2004 give me an error. I know it. Mappoint2006 can calculate between 0-100 Miles.

But over 50 Miles i have the SAME ERROR!! Why?

I changed the reference of "Microsoft MapPoint 11.0 Object Library (Europe)" to "Microsoft MapPoint 13.0 Object Library (Europe)"

Thanks for your help
Maik
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
2004>2006, 50miles or 100miles, or or, problems, update, vbaexcelmakros


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/update-mp-2004-2006-now-problems-vba-excel-makros-50miles-100miles-7897.html

Posted By For Type Date
The Magazine for MapPoint - MP2K Magazine This thread Refback 06-24-2008 01:50 PM

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
Mappoint 2006, C#, VS 2008, Vista, COM object problems jovo Development 7 09-21-2008 06:22 PM
Using Autoroute 2007 to update MapPoint 2006 Jonathan Shields MapPoint 2006/2009 Discussion 8 02-04-2008 10:45 AM
Problems exporting MapPoint data to Excel in embedded map o0beaner MapPoint 2006/2009 Discussion 4 03-12-2007 03:14 PM
Link Data to Excel update MP resets or can't place address GEB MapPoint 2006/2009 Discussion 3 10-01-2005 05:30 AM
MapPoint 2004 [EU] Routing problems peterw MapPoint 2006/2009 Discussion 1 01-05-2004 12:37 PM


All times are GMT -5. The time now is 12:09 PM.


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