The resulting file will be like:

"text", "text1", "text3"

CSV format

On Thu, 21 Oct 2004 01:39:02 -0700, Angelo
wrote:

The resulting file will be like:

"text", "text1", "text3"

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...b;en-us;291296
XL2002: Procedure to Export a Text File with Both Comma and Quote Delimiters

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

http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy

"Angelo" wrote in message
...
The resulting file will be like:

"text", "text1", "text3"

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!)

Angelo wrote:

The resulting file will be like:

"text", "text1", "text3"

--

Dave Peterson

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

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
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!)

Angelo wrote:

The resulting file will be like:

"text", "text1", "text3"

--

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.



Tom Ogilvy wrote:

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

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
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!)

Angelo wrote:

The resulting file will be like:

"text", "text1", "text3"

--

Dave Peterson


--

Dave Peterson