Thanks Tom.
As always, I appreciate your mastery.

Seems text document is wrapping lines
Notepad tells me 9500 lines
However, output to xl ends at row 5499

I guess I thought the VBA would read the blank rows
and output those as well.

Any comments

--
gos

-----------------------------------------------------------------------
goss's Profile: http://www.excelforum.com/member.php...nfo&userid=460
View this thread: http://www.excelforum.com/showthread.php?threadid=27889

Excel will read blank lines in a text file. However, you may not have any.

If Notepad is wordwrapping long lines, that is only for readability
purposes. The single lines don't become two lines just because they are
displayed with word wrap. A line break is indicated by vbCRLF combination.
Line Input reads everything up to the vbCRLF combination.

from help on Line Input:
The Line Input # statement reads from a file one character at a time until
it encounters a carriage return (Chr(13)) or carriage return-linefeed
(Chr(13) + Chr(10)) sequence. Carriage return-linefeed sequences are skipped
rather than appended to the character string.


--
Regards,
Tom Ogilvy
..


"goss" wrote in message
...

Thanks Tom.
As always, I appreciate your mastery.

Seems text document is wrapping lines
Notepad tells me 9500 lines
However, output to xl ends at row 5499

I guess I thought the VBA would read the blank rows
and output those as well.

Any comments?


--
goss


------------------------------------------------------------------------
goss's Profile:
http://www.excelforum.com/member.php...fo&userid=4602
View this thread: http://www.excelforum.com/showthread...hreadid=278899