Hello group,

I'm creating a textfile from Excel that needs to be imported by a third
party.

code that writes the file

fStatus ("Opening Export File")
Close #1
Open "theFile.txt" For Output As #1
Print #1, header
fStatus ("Writing Export File")
For Each cell In Selection
If cell.Value < "no entry" Then
Print #1, cell.Text
End If
Next cell
Print #1, trailer
fStatus ("Closing Export File")
Close #1

The routine works like a charm. The third party is complaining about the Hex
0A and Hex 0D (CR & LF) at the end of each record because it's making the
record length too long for his import process.
They claim that they need only one character and advised me to use the
command unixTOdos the realize this

Questions

- anyone have a clue how to approach this?
- how can i replace CHR(10)&CHR(13) with just CHR(10) after the file is
created
- is there a direct way to avoid the chr(10) & chr(13) to be written at the
end of each record from VBA?


Thanks a bunch

Edwin