Hi

I'm producing delimited text files that are to be imported into Excel.
Is there something that I could write to force Excel to make a
carriage return? Like writing \n or similar in the textfile.


/Johnbon

You mean so that excel will read the file and put separate lines on separate
rows.

It should do that automatically. It will see the end of line as being
marked by two characters a Carriage Return and LineFeed combination.

This is the windows standard. I don't recall what the Unix standard is - it
is either the Carriage return alone or the linefeed alone (I believe LF).
In any event, I believe Excel will also treat this as a newline indicator.

--
Regards,
Tom Ogilvy


"JohnBon" wrote in message
om...
Hi

I'm producing delimited text files that are to be imported into Excel.
Is there something that I could write to force Excel to make a
carriage return? Like writing \n or similar in the textfile.


/Johnbon

Hej

Yes, but I dont' want the text file to have visible Carriage Returns.
It would be better if I just could write some character like \n or
vbCRLF. Is it possible?

/Johnbon


"Tom Ogilvy" wrote in message ...
You mean so that excel will read the file and put separate lines on separate
rows.

It should do that automatically. It will see the end of line as being
marked by two characters a Carriage Return and LineFeed combination.

This is the windows standard. I don't recall what the Unix standard is - it
is either the Carriage return alone or the linefeed alone (I believe LF).
In any event, I believe Excel will also treat this as a newline indicator.

--
Regards,
Tom Ogilvy


"JohnBon" wrote in message
om...
Hi

I'm producing delimited text files that are to be imported into Excel.
Is there something that I could write to force Excel to make a
carriage return? Like writing \n or similar in the textfile.


/Johnbon