excel save as csv - force text qualifier on every text field

N

Newbie-Don

I need to generate a csv file that encloses every text field with a double
quote like this - "abc", "def","ghi", etc.
Currently, excel will do this ONLY with fields that contain a comma like
this - "word1, word2", def, ghi

Any help would be much appreciated!
 
N

Newbie-Don

got it - thank you!!

Tom Ogilvy said:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213448&Product=xlw
XL2000: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default.aspx?scid=kb;en-us;291296&Product=xlw
XL2002: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default.aspx?scid=kb;en-us;123183&Product=xlw
How to export data to a text file with comma and quote delimiter in Excel
Click to expand...
 
O

omiedog

Hello
I have excel 2002 and I need a Text File with Both Comma and Quote
Delimiters, I am trying to use this on my file, but I keep getting

Run Time Error '6'
Overflow

I was just wondering if this should still work or not? And if it should
maybe why it is not?
Thanks for your help, not much of a visual basic programmer
 
Top