CreateTextFile.WriteLine seems to insert double quotes at the beginning and end of ln

I have an Excel spreadsheet with a button that execute a macro. The macro reads the rows one by one and creates a text string from the column. The string is written out to a text file.
A text file generated by a user contains double quotes at the beginning and the end of each line in the output file. I opened the spread sheet on my machine and the double quotes do not show up.

Sample code:

Please Login or Register  to view this content.

.... more....

Sample output
OK
exec some_pkg.some_proc(....);
exec some_pkg.some_proc(....);
exec some_pkg.some_proc(......);
Bad
"exec some_pkg.some_proc(....);"
"exec some_pkg.some_proc(....);"
"exec some_pkg.some_proc(......);"

Hello Zampano,

Your problem isn't related to how the data is written to the file, but how it is converted. When importing a Text file to a worksheet using the TextToColumns method, you can specify how the text should appear by setting the TextQualifier argument.

The general syntax is...
Expression is a Range object
expression.TextToColumns(Destination, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, DecimalSeparator, ThousandsSeparator)

The text qualifier can be one of the following XlTextQualifier constants: xlTextQualifierDoubleQuote, xlTextQualifierSingleQuote, or xlTextQualifierNone. The default value is xlTextQualifierDoubleQuote.

Sincerely,
Leith Ross