Writing a .txt file

[Claus]

I am having trouble writing a .txt file with non-numeric
fields delimited with ".

In my macro I prepare the data in the format I want. But
I have tried every type of "save as" and cannot get the "
around the text column data. The data should look like
this:
"1234","E","OT",8.5,,,,,,"9/26/2004"

Note first column is an employee id, the last column is a
date. How can I write a file that would give me this
format?

 

[Tom Ogilvy]

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

 

[Claus]

Tom,

Thank you very much. This is just what I needed.

Claus