Jump to content

Excel To Gpx Waypoint Conversion Tool


Recommended Posts

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.

Link to comment
Share on other sites

  • 2 months later...
  • 6 months later...
  • 3 weeks later...

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

 

 

Link to comment
Share on other sites

  • 4 months later...
  • 3 weeks later...
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"

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...