Excel To Gpx Waypoint Conversion Tool

[GPS Fan]

Oh, I forgot to add that when clicking "Debug" in the error dialogue, it appears that the error occurs at this line:
"DescString = Application.Trim(SelectedExcel2GPXRange.Cells(RowIdx, 2))"

... or at least that is the line highlighted in yellow in the Debug window.

[Saifan Pilot]

Yeah, it seems to be a limitation of the macro language of Excel.

I'm not sure why you would want such a long description. Foreflight description only supports only the first 30-40 characters.

Garmin GPS's only support 16 characters or so for description.

 

[GPS Fan]

Thanks for the reply.  Yeah, Microsoft Office is a constant experience with limitations. ;-)

I'm importing waypoints into caltopo, and attempting to cram as much information in the description as I can.  You can get a lot in 256 chars, though.  

Thanks again for making this tool available... it's really nice, and really useful.

[Saifan Pilot]

Probably a limitation for Excel

[dharrington]

Signed up just to get this, and to thank you 😄.

[JRMWalsh]

Hi,

I downloaded this to try it and found a couple of bugs.

Firstly I use Excel 2003 on a Windows 97 computer.

Also, I write Excel macros so I can follow your macro and its logic.

Bug 1

I found that the line

"OutputPath = ThisWorkbook.Path"

Causes the error
    Run-time error '429':
    ActiveX component can't create object

I understand what this line does, so I changed it to

    OutputPath = ActiveWorkbook.Path

which made it work as you intended it to.

I have written macros to do this same thing but I used a completely different method which

was very robust. I put the path into a cell and the filename into a different cell where the

user could see them and feel comfortable with what the macro was doing.

Bug 2

I found that no matter whether I check the GPX button or the KM button the output file is given the extension " .kml "

I don't know if this is just a file-naming error, or whether the macro writes km files no matter which button is checked.

I might be able to help you with the macro if that would help you (or if you are very busy)?

Please let me know.

Regards

Mike Walsh

 

 

[JRMWalsh]

Also, there are two non-critical typo errors per:

        'Ouotput Path for Mac 1

        'Ouotput Path for Mac 2

I can see that these two lines are commented out and do not do anything.

 

 

[Saifan Pilot]

Hello,

I developed this in Excel 2011. Excel 2003 is outdated, so that might be the issue.

I'll have to download Excel 2016 and try it out on Mac and Windows and see what happens.

Thank you for the feedback.

[iviax]

Hello Saifan Pilot,

is there a possibility to create a gpx route file istead of only waypoint files?

 

Best regards,

Max

[Saifan Pilot]

On 2/12/2019 at 4:53 PM, iviax said:

Hello Saifan Pilot,

is there a possibility to create a gpx route file istead of only waypoint files?

 

Best regards,

Max

Just load the waypoint into Garmin Basecamp, highlight the points you want, the right black and select "Create Route from Waypoints"