mibushk, I think we need to go over some basics. I can't follw what you are doing.
We can deal with non-visible chars in a special way in low-level programs. The end of line is done in perhaps four different ways on computer systems. But you normally do not have to remove or add it to any text you are nursing.
At the DOS command line {actually the Windows command line} items are separated by spaces. Different programs have different command line options. When a program reprieves a command line options it is not really the command interpreter that is doing the work. The command interpreter just gives it to the program. Of course, the command has to be on one line with no end of line until the end of line.
In VBA and other versions of MS basic there is a specific way to write a line of text without en-of-line markers until the last item in the line. This is true of all modern computer languages. You do not have to remove or transform end-of-line chars. They are not sent unless you specified them in you write statement. But you do have to indicate how items are exasperated, unless the program does not require separation or delimiting of items.
Please, I am not trying to talk down to you. But it seems like you want to write code at a low-level when you don't have to.
Without knowing what program you use with VBA I have to just guess.
To write one line with a number of fields and then finish with a end of line, hound would do it like this:
Write request$, option$, daytime$, send$
WrinteLN
That is not real code, it shows items separated from northeaster and then an end of line given. In this dialectic the $ means i not a number, but a string. The commas may generate tabs or spaces. Again, that depends on the dialect.
I hope this is of some help. Pardon my grammer.