+ Reply to Thread
Results 1 to 4 of 4

saving text to a file - getting rid of quotes

  1. #1
    Registered User
    Join Date
    04-28-2009
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    38

    saving text to a file - getting rid of quotes

    I want to save a string of text to a plain text file. I didn't know how to do this, and using Help in Excel 2000 didn't shed any light, so I googled and based on what I found, wrote the following file. I don't understand a lot of the details, but it works.

    Please Login or Register  to view this content.
    But ... the file it produces has text "Hello world" _including_ the quotes.

    Any suggestions for modifying the code to eliminate those quotes?

    thanks in advance,
    David

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: saving text to a file - getting rid of quotes

    hi
    Try this

    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    04-28-2009
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    38

    Re: saving text to a file - getting rid of quotes

    Thanks pike, just what I needed.

    I'm trying to understand it. I hope this makes sense: Doing Write writes the string - as a string and therefore delimited by quotes - into the file.

    Doing Print takes the string and puts _its contents_ into the file (instead of sending the contents to a printer).

    While I'm learning : if I only have one file open at a time, is it OK to use #1 instead of using the Freefile function to get an integer?

    David

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: saving text to a file - getting rid of quotes

    arr... yes but only 1 to 511

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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