Jump to content
Sign in to follow this  
Saifan Pilot

Excel To Gpx Waypoint Conversion Tool

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

 

 

Share this post


Link to post
Share on other sites

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.

 

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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"

Share this post


Link to post
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...
Sign in to follow this  

×
×
  • Create New...