MapPoint Forums

MapForums

Community of MapPoint and Bing Maps Users and Developers




export to excel (calculate a new file)

This is a discussion on export to excel (calculate a new file) within the MapPoint Desktop Discussion forums, part of the Map Forums category; hi, when i export mappoint file into excel, you get a mappoint sheets (w/set name & records). I would like ...


Go Back   MapPoint Forums > Map Forums > MapPoint Desktop Discussion

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 07-09-2009
Junior Member
White Belt
 
Join Date: May 2009
Posts: 1
export to excel (calculate a new file)

hi,

when i export mappoint file into excel, you get a mappoint sheets (w/set name & records).

I would like to get a along name set & records : a new file named Price which is the sum of every record price's. (one set name = 50-75 records)

Price file is already on every record .

is it possible to create this kind of file with a code?

thanks
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 07-09-2009
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 3,420
Blog Entries: 3
Re: export to excel (calculate a new file)

Yes, I think you would just do it in Excel. Write an Excel macro to go out and grab the data and sum it?

Maybe you can post an example of one of your spreadsheets and describe precisely what you want to do.

Eric
__________________
~ Now taking orders for MapPoint 2010 ~
~~
~ 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
Reply

Tags
calculate, excel, export, file


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/export-excel-calculate-new-file-10749.html

Posted By For Type Date
The Magazine for MapPoint - MP2K Magazine This thread Refback 07-11-2009 05:21 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
Excel UDF to calculate distances using lat/lon pherrero MapPoint Desktop Discussion 1 4 Weeks Ago 10:15 PM
Calculate driving distance matrix in Excel DaveOKC MapPoint Desktop Discussion 9 12-09-2008 05:46 PM
[b]How do I export data into an ACCESS (mdb) file using VB6? rmozes MapPoint Desktop Discussion 0 08-05-2003 09:17 AM
Export MapPoints Direction to GPS File. HELP Anonymous MapPoint Desktop Discussion 2 06-20-2003 03:09 AM
I want to be able to export to excel a file that h.... Anonymous MapPoint Desktop Discussion 1 07-18-2001 01:29 PM


All times are GMT -5. The time now is 09:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.2
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 55 56 57 58 59 60 61 62 63 64 65 66 67