Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

xlmicrosoft Mappoint

This is a discussion on xlmicrosoft Mappoint within the MapPoint Desktop Discussion forums, part of the Map Forums category; So I'm calling Mappoint from within a VBA subroutine... Dim SysApp As New MapPoint.Application Dim SysMap As MapPoint.Map Dim SysRoute ...

  1. #1
    andriy is offline Junior Member Yellow Belt
    Join Date
    Mar 2007
    Posts
    16

    xlmicrosoft Mappoint

    So I'm calling Mappoint from within a VBA subroutine...

    Dim SysApp As New MapPoint.Application
    Dim SysMap As MapPoint.Map
    Dim SysRoute As MapPoint.Route
    Dim SysLoc1 As MapPoint.Location
    Dim SysLoc2 As MapPoint.Location

    Application.ActivateMicrosoftApp xlMicrosoftMappoint

    and the calculator pops up instead...

    I've opened Mappoint before from within an excel function, but this is silly...
    My references are up mappoint 13.0 object library, mappoint utilities 1.0 type library, but am getting a "conflict message" when referencing mappoint control 13.0...

    thanks for any input,
    andriy
    Last edited by andriy; 01-14-2008 at 12:31 PM.

  2. #2
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    Re: xlmicrosoft Mappoint

    xlMicrosoftMappoint isn't a defined constant, so VBA doesn't really know what it's activating.

    You probably want to simply activate the MapPoint application you already created in your variable "SysApp", by using the following:

    Code:
    SysApp.Visible=true
    SysApp.UserControl=true
    SysApp.Activate()
    HTH
    -Paul

  3. #3
    andriy is offline Junior Member Yellow Belt
    Join Date
    Mar 2007
    Posts
    16

    Re: xlmicrosoft Mappoint

    Thanks.
    I didn't realize Mappoint was already created once I declared it (and allocated memory).

    Thanks for your patience with my growing skillset.
    Andriy

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91