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

Programming using excel VBA... No GPS

This is a discussion on Programming using excel VBA... No GPS within the MapPoint Desktop Discussion forums, part of the Map Forums category; I was hoping someone could help me out. I made a program in Excel vba that opens up a mappoint ...

  1. #1
    KUSteveo is offline Junior Member White Belt
    Join Date
    Nov 2005
    Posts
    1

    Programming using excel VBA... No GPS

    I was hoping someone could help me out. I made a program in Excel vba that opens up a mappoint map and converts location data and puts pushpins at that location. I need to find a way to track my position in the mappoint map I opened with excel. If I go to the GPS menu all of the selections are greyed out, but if I open up a new mappoint outside of excel I can track my position. I'm assuming this is due to the gps add-ins not being initialized when I open a new map trough excel, but I dont know what to do to fix the problem. I have searched the fourms and people have had this problem before, but no one seemed to find a soultion to this, just found another way of doing what they needed done.

    If anyone can help me out I would be very thankful!

  2. #2
    mrgcav is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    3

    Re: Programming using excel VBA... No GPS

    KUSTEVO,

    We need to insert maps into an excel document using an address & zip code. We need picture of the location (location marked & Centered in map) with a one mile radius and another map with a five mile radius.
    We also need to convert the Address into a Longitude & Latitude GPS coordinates.
    We would like a copy of your program.

    We are in Milwaukee, Wisconsin.

    Elmbrook Electronics Inc
    Elmbrooke@Gmail.com

  3. #3
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Programming using excel VBA... No GPS

    mrgcav,

    I created a program that I named MapSnap which:
    - runs through a jet database (can change to Excel)
    - locates, geocodes, and adds a pushpin for each record
    - save a picture based upon your chosen specs.

    Mike Mattys
    (See my website contact page)

  4. #4
    mrgcav is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    3

    Re: Programming using excel VBA... No GPS

    Mattys Consulting,
    Mapsnap, Sounds much like what I am after.
    We do deliveries based upon address and zip code and need to generate maps for those deliveries.
    Could an excel macro be created ?
    I could not find your website
    Please email me directly at elmbrooke@gmail.com
    Or call (262) 789-7737


    mrgcav

  5. #5
    Elliot Bendoly's Avatar
    Elliot Bendoly is offline www.excel-blackbelt.com White Belt
    Join Date
    Sep 2008
    Location
    Atlanta
    Posts
    8

    Re: Programming using excel VBA... No GPS

    For those interested in leveraging Excel and/or VBA with MapPoint, I have a new reference out titled "Excel Basics to Blackbelt" (Cambridge Press 2008 ). Lot's of tricks to make use of. I've made a number of applications that integrate MapPoint with other apps through Excel and VBA as well.
    Here's a video link to a redux of a Webinar I gave for both Palisades and Cox Communication recently:
    http://www.new.facebook.com/video/vi...?v=35676304438
    The text is currently available at a promotional discount at Amazon.com
    Enjoy
    Last edited by Eric Frost; 09-20-2008 at 02:57 PM.

  6. #6
    mrgcav is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    3

    Re: Programming using excel VBA... No GPS

    To all, Please note... we have little programming experience and require a ready made solution.
    Elmbrook electronics Inc.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ambiguous messages ( programming or not programming? )
    By Mohamed in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-13-2006, 04:35 PM
  2. Programming MapPoint via .NET
    By Anonymous in forum MP2K Magazine Articles
    Replies: 1
    Last Post: 02-21-2006, 10:42 AM
  3. MPControl embedded in excel - excel loses functionality
    By ruyasan in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-20-2004, 04:41 AM
  4. How to programming using VC6.0
    By confach in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 03-01-2004, 06:25 AM
  5. Programming in VB.Net
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 12-01-2003, 10:52 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