Reading Text File, stopping unexpectedly.

[hamerish]

Hi,

I have a text file(.XER), VBA can iterate through the file until it gets to this line:

Screenshot(middle line)

https://unsee.cc/81c0f29e/

Copied and pasted
%R 190489 77906 nvirnImpaAssem/SiteWsteManagPlan�@_

It seems as though this line causes the while loop to exit.

Can anyone shed some light on why? and if there is a solution to this issue.

thanks for any help

 

[Norie]

How are you iterating through the file?

If it's line by line have you considered reading in the entire file then splitting it out into rows/lines.