Excel Text Export: Commas creating unwanted Inverted Commas

the exported text file includes inverted commas around code which has commas.

Click to expand...

I think you are talking about single quotes (not inverted commas). These are often used as Text Qualifiers in SQL, csv text files, etc.

Can you post the relevant section of code, and a small sample of your data so we can try to reproduce the behavior?

I've since found a solution, it seems most people refer to inverted commas as "quotation marks" which threw my searches off a little - so in order to export excel cells to text without quotation marks here is the code:

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

Open "c:\MyOutput.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
End Sub

it seems most people refer to inverted commas as "quotation marks" which threw my searches off a little

Click to expand...

I have actually never heard anyone refer to them as "inverted commas". Commas usually are on the bottom of a cell.

There are two types of quotation marks, single and double. SQL uses single quotation marks a lot.

Glad you got the issue sorted out.