Getting Rid of Extra Quote Marks in Exported Text Files

Marvelous! Thanks so much. Now in 2016 it's STILL a problem. And with a little 'Export' button added, linked to the macro, perfection!

Brilliant, thank you

Thank you!!!

The easiest solution I have found is to just open the Excel spreadsheet and highlight what you want (even the entire spreadsheet) and then copy & paste it directly into NotePad.

Thanks a lot.. I have been searching a solution for this issue for sometime now. This code worked like a charm.

Hi! i am trying to use your suggestion. I am having a text file and I want to Output that using the VBA in MS Excel. When I use the Output command, I am getting a "Permission Denied: Error 70" error. I believe this is because I am trying to Output a write-protected text file. Can you suggest me the vba code required to remove the write-protection on this text file. This would help me a lot and I greatly appreciate it.

Amaising Macro

Above code worked for my problem...Thank you...But small doubt what is WEND in the above code?

If i convert excel file into csv, when i open that converted file in notepad it is showing some extra double quotes. how can i remove this quotes?

Or do it the easy way. Export the file as CSV. Edit it using Notepad. Remove all the Quotes and save it. Done.

This is an excellent tip!

Also found a lot of crappy "solutions" on the internet, before this one!!! I new I had to do something with the [Print] command...
In addition, I only needed to start with replacing my existing qoutes:

Cells.Replace What:="""", Replacement:="'", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

Is there anyway to do this on just a single column within an existing macro?

I have an exported webpage in Excel that we run a lengthy macro on, but still has hidden quotations on only 1 column (G) that we manually find/replace via the text file.

I would like to be able to add this into the existing macro for column G only.

I'm teaching myself VB so I would appreciate any assistance!

Thanks!

This worked great. Thanks!
One alteration I made was to open the file after saving it(at the very end). To do this I added the following code at the end(See full example below): Shell "notepad++.exe ""c:tempMyOutput.txt""", vbNormalNoFocus



Sub Export()
Dim r As Range, c As Range
Dim sTemp As String

Open "c:tempMyOutput.txt" For Output As #1
For Each r In Selection.Rows
sTemp = ""
For Each c In r.Cells
sTemp = sTemp & c.Text & Chr(9)
Next c

'Get rid of trailing tabs
While Right(sTemp, 1) = Chr(9)
sTemp = Left(sTemp, Len(sTemp) - 1)
Wend
Print #1, sTemp
Next r
Close #1
Shell "notepad++.exe ""c:tempMyOutput.txt""", vbNormalNoFocus
End Sub

Thanks! This is great. Have been struggling with this for a couple of weeks and you have solved it!

Thank you so freaking much for this elegant and effective macro! This page just ended two hours of frustrated google searches.

Hi, interesting tip. Excel also puts quotation marks around email addresses one wants to copy into the TO-line of Outlook when there is more than one email address in a cell. Can this macro be adapted to remove the quotation marks while transiting through the clipboard?