MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Using a macro to get a map into excel

This is a discussion on Using a macro to get a map into excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, I am using excel to print invoices for my company and want to insert a small map from mappoint ...


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

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



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-23-2004
Junior Member
White Belt
 
Join Date: Mar 2004
Posts: 2
Using a macro to get a map into excel

Hi,

I am using excel to print invoices for my company and want to insert a small map from mappoint or autoroute for the delivery driver. I know a small amount of VB and was wondering if anyone knew how to write a macro in excel that could do this.

I have the customers postcode (uk) in excel and need a 3 inch square image covering aproximately 1 sq mile.

If anyone can help it would be much appreciated.
Thanks,

Jim
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 03-23-2004
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,472
Blog Entries: 1
Chris Gebhardt wrote some simple examples, see the article section: "Using MapPoint from Word, Excel, and Access". There are many more examples, look at bit thoughout the site.

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 03-29-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
jimbob,

I've written a macro which will produce maps in excel.

If you want I can send you the VBA code and you can take it from there. My code uses lat/longs.

adam
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
excel, macro, map


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
setting up macro in excel to extract lat/long from map point TransportationNut05 MapPoint 2006/2009 Discussion 2 08-24-2005 11:45 AM
Possible to batch file/macro Import Data Wizard? Oyjord MapPoint 2006/2009 Discussion 0 05-31-2005 06:05 PM
Locate City and zip code using lat and long (Excel Macro) sberhe Wish List 0 04-01-2005 10:31 AM
Select city iwth VB macro tanguy_laverdure MapPoint 2006/2009 Discussion 0 12-12-2003 09:38 AM
updatelink using macro in Excel XP amyles MapPoint 2006/2009 Discussion 0 07-17-2003 02:26 AM


All times are GMT -5. The time now is 12:01 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