EOF and expression test

[pong]

i am learning do loop and eof statement through the following
but does anybody have an idea about what the code doing
For my understanding ,the code trying to find if the "total" column exists on the first row.
but what are these "Do While Not EOF(1)
Line Input #FileNumber, Data"
why do i need them

Sub DemoWhileClause()
' Page 115 at the bottom
Open ThisWorkbook.Path & Application.PathSeparator & "Invoice.txt" For Input As #1
r = 1
Do While Not EOF(1)
Line Input #FileNumber, Data
If Not Left(Data, 5) = "TOTAL" Then
' Import this row
r = r + 1
Cells(r, 1).Value = Data
End If
Loop
Close #1
End Sub

 

[xenou]

EOF means "End of File".
Line Input means "read the current line". I think basically it moves to the next line too, after reading the current line.

Together, this means you are reading the text file sequentially, starting with the first line, continuing one line at a time, and stopping when the file marker reaches the "EOF" position when there is no more file to read. Incidentally, an empty file would be EOF right away. So this also stops you from trying to read an empty file.

I'm sure someone can give a more technical explanation but on the whole you'll find you just get used to it as you become familiar with text file input/output.

 

[pong]

EOF means "End of File".
Line Input means "read the current line". I think basically it moves to the next line too, after reading the current line.

Together, this means you are reading the text file sequentially, starting with the first line, continuing one line at a time, and stopping when the file marker reaches the "EOF" position when there is no more file to read. Incidentally, an empty file would be EOF right away. So this also stops you from trying to read an empty file.

I'm sure someone can give a more technical explanation but on the whole you'll find you just get used to it as you become familiar with text file input/output.

This helps a lot. but what is usually entered after line input ?

 

[shg]

The file number, in your case, 1:

Line Input #[COLOR=red]1[/COLOR], Data

 

[pong]

The file number, in your case, 1:

Line Input #[COLOR=red]1[/COLOR], Data

Yes. But what does the 1 represent ?

 

[djreiswig]

The 1 is the file number as shg said. It is the same as in your open statement. You could have more than one file open so you have to specify which file to read from. If you opened two files at the same time the second file could be #2.