Excel Macro to Generate GPX Files

 

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

--
John, Nuvi 65LMT, Mac User

Ampersands

jpbrannigan wrote:

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

jthomas_31 wrote:

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