View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
omiedog omiedog is offline
external usenet poster
 
Posts: 1
Default excel save as csv - force text qualifier on every text field


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


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...96&Product=xlw
XL2002: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default...83&Product=xlw
How to export data to a text file with comma and quote delimiter in Excel


--
Regards,
Tom Ogilvy


"Newbie-Don" wrote in message
...
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!