+ Reply to Thread
Results 1 to 4 of 4

Quotes in my data when saving as a text

  1. 06-14-2016, 01:44 PM #1
    BG1983
    BG1983 is offline
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Quotes in my data when saving as a text

    Hi, I am using the following code to save data as a txt file but some of the data is being saved with quotes around it when it is copied. How do I fix this?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 06-14-2016, 01:57 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: Quotes in my data when saving as a text

    Guess you need to look at which bits get saved with quotes and which ones don't. Are there any commas or other non-text characters present?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 06-14-2016, 02:08 PM #3
    BG1983
    BG1983 is offline
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: Quotes in my data when saving as a text

    Here's some examples..

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 06-14-2016, 02:34 PM #4
    BG1983
    BG1983 is offline
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: Quotes in my data when saving as a text

    I figured it out --- changed this line
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Saving spreadsheet as text without unwanted double quotes (")
    By Tempe_VBA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2014, 10:14 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. saving text to a file - getting rid of quotes
    By madhg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2012, 07:08 PM
  4. Excel adding QUOTES when Copying/Pasting or Saving as TEXT
    By Niper in forum Excel General
    Replies: 0
    Last Post: 10-05-2010, 09:08 AM
  5. Saving Text Files Without Quotes
    By John Abbot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2007, 02:25 PM
  6. saving an excel file as text without text in quotes
    By John in forum Excel General
    Replies: 2
    Last Post: 12-06-2005, 02:25 PM
  7. saving as text adding extra quotes?
    By Corey Wirun in forum Excel General
    Replies: 2
    Last Post: 05-13-2005, 01:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1