View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claus[_2_] Claus[_2_] is offline
external usenet poster
 
Posts: 2
Default Writing a .txt file

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?