View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] stephan.anstoetz@gmail.com is offline
external usenet poster
 
Posts: 2
Default Remove last CRLF in text file

Hi there,

I want to write a string from VBA into a text file. This file is an
input file for an Unix application, i.e. LF as the last character in a
file.
The Print statement does put me a CRLF at the end of every line. I got
around this problem to first concatenate the whole string with the
chr(13) LF and at the end write it into file.
This leaves me one CRLF at the very end of the file.

How do I get rid of this?
I tried to shorten the string by one character but than the string is
too short.
I re-read and re-wrote the file omitting the last line. No way. No
idea.

Any help is appreciated.
S.