+ Reply to Thread
Results 1 to 4 of 4

Remove quotes in text file after converting Excel to Text in VBA Access 2002

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    Montreal
    MS-Off Ver
    Excel 2003
    Posts
    7

    Remove quotes in text file after converting Excel to Text in VBA Access 2002

    Hello,

    I want to convert from Excel to Text using VBA Access 2002, works OK but it puts the quotes at the begininng and end of each line

    Thanks

    This is the result:

    Please Login or Register  to view this content.
    Instead of this

    Please Login or Register  to view this content.

    This the code from VBA

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    01-06-2014
    Location
    Montreal
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Remove quotes in text file after converting Excel to Text in VBA Access 2002

    Hello, concerning my thread...somebody has encountered the same problem writting to a text file. The quotes seem to be created when the Write #2
    Thanks

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Remove quotes in text file after converting Excel to Text in VBA Access 2002

    Use Print instead of Write.

    PS Couldn't you just save the file as text instead of doing things row by row?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    01-06-2014
    Location
    Montreal
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Remove quotes in text file after converting Excel to Text in VBA Access 2002

    PRINT #2 works perfectly. Thanks a lot Norie

+ 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. [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
  2. Remove text between quotes, variable length and number of quotes
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2011, 10:40 AM
  3. Copy Excel to Text file and pass Text file to Access Table
    By robbie_xcell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 01:53 PM
  4. [SOLVED] Remove Quotes from Write To Text File
    By astrodon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2010, 09:36 AM
  5. Replies: 2
    Last Post: 12-06-2005, 02:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1