Stop reading text file before EOF

[Yvaine]

I am trying to read a text file with over 100,000 lines, but i realized that it stopped at line 32,767. Anyone could tell me the reason?

[orange]

I am trying to read a text file with over 100,000 lines, but i realized that it stopped at line 32,767. Anyone could tell me the reason?

32767 is max size of integer variable.
Were you using a counter during this read?
If so, change the data type to double or long.

[Tommy]

In addition to what orange has posted, you need to check for EOF.
[VBA]
While Not EOF(#FileNumber)
'Code for reading
Wend
[/VBA]