Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cut and Paste Text with CRLF into Single Cell | Excel Discussion (Misc queries) | |||
Remove headers from text file | Excel Discussion (Misc queries) | |||
Change file name - remove specific text | Excel Programming | |||
CRLF in .cvs file | Excel Programming | |||
CRLF in text box | Excel Programming |