VBA Line Input Statement
Line Input Description
Reads a single line from an Open sequential file and assigns it to a string.
Line Input Syntax
1 |
<strong>Line Input</strong> #FileNumber, VarName |
The Line Input statement contains 2 arguments:
FileNumber: Any valid file number.
VarName: Valid Varient or String variable name.
Examples of Excel VBA Line Input Statement
To test the Line Input Statement, create a text file “test.txt” on the D drive.(D:\test.txt) Assume that the content of the file is as following.
1 2 3 |
abc 1 2 3 xy z |
Please run the following code.
1 2 3 4 5 6 7 8 9 10 11 12 13 |
Sub LineInput_Example() Dim strLine As String Dim strContent As String Open "D:\test.txt" For Input As #1 ' Open file. Do While Not EOF(1) ' Loop until end of file. Line Input #1, strLine ' Read line into variable. strContent = strContent & strLine Loop Close #1 ' Close file. MsgBox strContent End Sub |
Then, the result will be as following.
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Learn More!