Saving as a text file with quotes AND commas

[John]

I need to have a text file with quotes and comma delimited i.e.
"C1","Anne","1429" etc.
The file exists as a comma delimitted text file. I open it in Excel
and add quotes using a vba macro.
If I save it as a .csv file it adds another set of quotes. If I don't
put the quotes in with the macro and save it as .csv it doesn't add
any quotes. If I save it any other way it doesn't have commas. HELP!!

 

[Earl Kiosterud]

John,

Get the Text Write Program (a workbook) from www.tushar-mehta.com. Don't
add the quotes. You can tell the program to put the quotes around all
fields.

 

[Kathy]

-----Original Message-----
I need to have a text file with quotes and comma delimited i.e.
"C1","Anne","1429" etc.
The file exists as a comma delimitted text file. I open it in Excel
and add quotes using a vba macro.
If I save it as a .csv file it adds another set of quotes. If I don't
put the quotes in with the macro and save it as .csv it doesn't add
any quotes. If I save it any other way it doesn't have commas. HELP!!
.

Have you tried saving it as an excel workbook?

 

[John]

I need to have a text file with quotes and comma delimited i.e.
"C1","Anne","1429" etc.
The file exists as a comma delimitted text file. I open it in Excel
and add quotes using a vba macro.
If I save it as a .csv file it adds another set of quotes. If I don't
put the quotes in with the macro and save it as .csv it doesn't add
any quotes. If I save it any other way it doesn't have commas. HELP!!

Thank you, the Text Write program did the trick.