Visual Basic for Applications Reference

Line Input # Statement

See Also    Example    Specifics

Reads a single line from an open sequential file and assigns it to a Stringvariable.

Syntax

**Line Input #**filenumber, varname

The Line Input # statement syntax has these parts:

Part	Description
filenumber	Required. Any valid file number.
varname	Required. Valid Variantor String variable name.

Remarks

Data read with Line Input # is usually written from a file with Print #.

The Line Input # statement reads from a file one character at a time until it encounters a carriage return (Chr(13)) or carriage returnlinefeed (Chr(13) + Chr(10)) sequence. Carriage returnlinefeed sequences are skipped rather than appended to the character string.