Visual Basic for Applications Reference

AtEndOfLine Property

See Also    Example    Applies To    Specifics

Description

Read-only property that returns True if the file pointer immediately precedes the end-of-line marker in a TextStream file; False if it does not.

Syntax

object.AtEndOfLine

The object is always the name of a TextStream object.

Remarks

The AtEndOfLine property applies only to TextStream files that are open for reading; otherwise, an error occurs.

The following code illustrates the use of the AtEndOfLine property:

Dim fs, a, retstring
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.OpenTextFile("c:\testfile.txt", ForReading, False)
Do While a.AtEndOfLine <> True
    retstring = a.Read(1)
    ...
Loop
a.Close