Table of contents
Collapse the table of content
Expand the table of content

Line Input # Statement

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

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


Line Input #filenumber, varname

The Line Input # statement syntax has these parts:

filenumberRequired. Any valid file number.
varnameRequired. Valid Variant or 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 return-linefeed ( Chr( 13 ) + Chr( 10 ) ) sequence. Carriage return-linefeed sequences are skipped rather than appended to the character string.


This example uses the Line Input # statement to read a line from a sequential file and assign it to a variable. This example assumes that is a text file with a few lines of sample data.

Dim TextLine 
Open "TESTFILE" For Input As #1 ' Open file. 
Do While Not EOF(1) ' Loop until end of file. 
 Line Input #1, TextLine ' Read line into variable. 
 Debug.Print TextLine ' Print to the Immediate window. 
Close #1 ' Close file. 
© 2018 Microsoft