Saving as a text file with quotes AND commas

  • Thread starter Thread starter John
  • Start date Start date
J

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!!
 
-----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!!
.
Click to expand...

Have you tried saving it as an excel workbook?
 
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!!
Click to expand...

Thank you, the Text Write program did the trick.
 
Back
Top