What file format that includes quotes and comma as delimiters?

[Guest]

The resulting file will be like:

"text", "text1", "text3"

 

[Myrna Larson]

CSV format

 

[Tom Ogilvy]

If you want all your text strings to be in double quotes, the CSV won't do
that. You have to use a macro:

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

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

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

CSV will just quote text strings that contain the delimiter.

 

[Dave Peterson]

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(You may be happy with Earl's version--right out of the box!)

 

[Tom Ogilvy]

I haven't look at Earl or JE's, but Chip's doesn't do what he asked.

 

[Dave Peterson]

I meant as a get started--not as a final product.

But IIRC, Earl has a worksheet of options that includes this feature.