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 4 of 4

Via Visual Basic code in Excel, how to Export Radius MpPt Data back?

This is a discussion on Via Visual Basic code in Excel, how to Export Radius MpPt Data back? within the Development forums, part of the MapPoint Desktop Discussion category; Community, I'm having a terrible problem in a programming class -- one the teacher can't even answer. I need help ...

  1. #1
    washuromeo is offline Junior Member White Belt
    Join Date
    Apr 2010
    Location
    Atlanta, GA
    Posts
    4

    Via Visual Basic code in Excel, how to Export Radius MpPt Data back?

    Community,

    I'm having a terrible problem in a programming class -- one the teacher can't even answer. I need help ASAP!

    Does anyone have any Visual Basic code to tell Mappoint to
    1. Select on a radius circle the user draws in an map embedded in an excel dashboard
    2. "Export data to excel" - sending that radius' info to excel

    3. Then how to store it in a consistent place where I can access it and use it for optimization later.

    Any help would be great!

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Via Visual Basic code in Excel, how to Export Radius MpPt Data back?

    When you say the "radius' info" - what info exactly? The coordinates of the shape? For an oval or circle it is lat/lon center, height, and width. For a freeform polygon, it is a series of vertice coordinates (lat/lon pairs).

    Or do you want to export a list of pushpins within the radius?

    Or something else?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    washuromeo is offline Junior Member White Belt
    Join Date
    Apr 2010
    Location
    Atlanta, GA
    Posts
    4

    Re: Via Visual Basic code in Excel, how to Export Radius MpPt Data back?

    Thanks for responding, Eric.
    When I say, "radius info" I mean the after the user draws a circle with the radius tool (its icon looks like a circle with a line from the center to the edge), they can right click the circle and select "Export data to excel." The map has something like population census tract data already on it, so it returns the count of people within that radius tool.

    Here are the steps I sent to my teacher. He's really good, but so far has been unable to help me with it. Here's what I had sent him:

    1. I must supply instructions for the user to a. "Right click
    and drag a zoom box to the desired area."
    b. Left click into the box to zoom in.
    c. Pull up radius tool by selecting View -> Toolbars ->
    Drawing on the top menu.
    d. Select the Radius tool
    e. Positioning the cursor where the hospital center will be, left
    click and draw a radius out to where they expect to serve the community.

    3. Then, we're trying to create a button that will do the following steps:
    a. Right click the radius circle in the map.
    b. Export the data to Excel
    c. Since exporting the data creates an entirely new workbook, we
    want the macro to then select and copy that data into a form where we can
    further manipulate it.

    4. We are trying to create a button that would "clear" the
    radius circle on the map and zoom out, so they can start over again.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Via Visual Basic code in Excel, how to Export Radius MpPt Data back?

    How far have you gotten? Let us know if you get stuck.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Basic - Zip Code Data (Bubble Diagram)
    By robertuva in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-27-2005, 03:01 PM
  2. how to add postal code to territories for an excel export ?
    By nat in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-25-2005, 06:23 AM
  3. Exporting Changed data back to Excel
    By kbeese in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-17-2005, 03:57 PM
  4. Visual Basic 6.0 generating a map based on access data
    By virgilar in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 03-11-2005, 08:27 AM
  5. Controlling Autoroute from Visual Basic code
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-26-2004, 10:47 AM

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