Determining If the End of a Text File Has Been Reached

In other issues of WordTips you learn how to access text files from within a macro. Another command associated with sequential text files is the EOF function. If used on an open file, EOF returns a True or False condition, which indicates if the internal file pointer is located at the end of the file. This function is most often used when inputting information from a text file, as shown here:

Open "MyFile.Dat" for Input as #1
J = 0
While Not EOF(1)
    J = J + 1
    Line Input sMyString(J)
Wend