Excel Macro to Generate GPX Files
Sat, 04/07/2007 - 12:46am
 |
  16 years
|
I just finish writing an Excel Macro to generate GPX files. This allows you to have dial-able (I think I just created a new word!) phone numbers.
Assumptions:
1) First line contains headers!
2) The file will be created where ever you installed Excel (Mac = /Applications/Microsoft Office 2004; PC = c:/program files/microsoft office; and it will be named the same as the tab (this by default to something meaningful like sheet1).
NOTE: POI Loader does not like "&" in the name or address.
Columns:
1) Latitude
2) Longitude
3) Name
4) Address
5) City
6) State
7) Zip
8) Phone
9) Symbol
The macro:
UGH! I forgot that all the formatting is removed. Email me If you would like a copy of this macro.
Other pages
Ampersands
NOTE: POI Loader does not like "&" in the name or address.
POI Loader expects its input to be URL-encoded. Then you can have an & in the name /address / description / link etc.
Actually, there's quite a lot of things that POI Loader doesn't like - Garmin seem to have written their own XML Parser ... for reasons best known to themselves. POILoader and Mapsource can't read some of the reference files on the Topografix website :-(
------------------------ Phil Hornby, Stockport, England ---------------------- http://GeePeeEx.com - Garmin POI Creation made easy »
email
I would like a copy of the macro but I don't see your email
Excel Macro
John will your macro work on windows as you show you use a mac?
johnm405 660 & MSS&T
Click on the link
I would like a copy of the macro but I don't see your email
Then click on the file name and save it to your computer,
Rodney.. oditius.htc@gmail.com BMW Zumo 550 HTC Touch Pro - Garmin XT