+ Reply to Thread
Results 1 to 2 of 2

Saving spreadsheet as text without unwanted double quotes (")

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Tempe, Arizona, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Saving spreadsheet as text without unwanted double quotes (")

    Hello Everybody,
    I would appreciate some guidance on the best way to get a text file from Excel without unwanted double quotes.
    The macro aims at converting the CSV output file from FlySight GPS to a GPX file.
    I am almost there.

    The GPX format ask for this format
    <trkpt lat="33.1013814" lon="-111.9382239">

    But I am getting
    "<trkpt lat=""33.1013814"" lon=""-111.9382239"">"

    I already got the right format in an Excel spreadsheet.
    But how can I complete the task from there ?

    The files are attached.

    Thanks for the help.

    Pierre

    Intermediate file not saved.xlsJ258 - Copy (2).txtJ258 - Copy (2).CSVFS to GPX v0.xls

  2. #2
    Registered User
    Join Date
    02-06-2013
    Location
    Tempe, Arizona, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Saving spreadsheet as text without unwanted double quotes (")

    Figured it out.
    I just transfer to a text file with the following code:

    Rem Transfer to Text file
    Open fName & ".gpx" For Output Access Write As #1

    For I = 1 To iLastRow
    Print #1, RwDt_wb.Sheets(2).Cells(I, 1)
    Next I

    Close #1

    The gpx data are kept into one column instead of 2 to keep it simple.
    There was no issues with ".
    Last edited by Tempe_VBA; 05-18-2014 at 10:15 PM. Reason: typo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-16-2013, 09:16 PM
  2. [SOLVED] Double Quotes using Chr(34) and Extra Quotes when saving as text file
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-26-2013, 12:26 PM
  3. Using "Append", adds unwanted double quotes. How to remove them?
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 09:35 AM
  4. Replies: 1
    Last Post: 10-14-2005, 10:05 AM
  5. [SOLVED] double quotes when saving in CSV
    By Kozmos241 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1