Posted to microsoft.public.excel.programming
|
|
Writing a .txt file
Tom,
Thank you very much. This is just what I needed.
Claus
-----Original Message-----
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
--
Regards,
Tom Ogilvy
"Claus" wrote in
message
...
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?
.
|