Results 1 to 3 of 3

Thread: Why the ""

  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Rockvale, Tennessee, USA
    Posts
    42
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Why the ""

    Hello, I have the text below in an excel file and I want to create a text file that contains this text. I'm using the following code to save it to a file but I get the following result in the file that's created. Can anyone help me eliminate these extra quote marks? Thanks, John

    Code:
    ActiveWorkbook.SaveAs ("C:\Temp\text.txt")

    Text:
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE en-export SYSTEM "http://xml.evernote.com/pub/evernote-export.dtd">
    <en-export export-date="" application="Evernote/Windows" version="4.1">
    <note><title>
    Title
    </title><content><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE en-note SYSTEM "http://xml.evernote.com/pub/enml2.dtd">
    <en-note style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
    Data
    </en-note>]]></content><created></created><updated></updated></note></en-export>

    Result:
    "<?xml version=""1.0"" encoding=""UTF-8""?>"
    "<!DOCTYPE en-export SYSTEM ""http://xml.evernote.com/pub/evernote-export.dtd"">"
    "<en-export export-date="""" application=""Evernote/Windows"" version=""4.1"">"
    <note><title>
    Title
    "</title><content><![CDATA[<?xml version=""1.0"" encoding=""UTF-8""?>"
    "<!DOCTYPE en-note SYSTEM ""http://xml.evernote.com/pub/enml2.dtd"">"
    "<en-note style=""word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"">"
    Data
    </en-note>]]></content><created></created><updated></updated></note></en-export>

  2. #2
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    Code:
        ActiveWorkbook.SaveAs _
            Filename:="C:\Temp\text.txt", _
            FileFormat:=xlTextPrinter
    PJ in FL

  3. The Following User Says Thank You to pjustice57 For This Useful Post:

    JohnSimmonds (2011-05-03)

  4. #3
    Lounger
    Join Date
    Apr 2001
    Location
    Rockvale, Tennessee, USA
    Posts
    42
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks pjustice57. John

Posting Permissions

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