Input # statement

Input # filenumber, variablelist

Input # statement reads data from a sequential file and assigns that data to variables.

The Input # statement has two parameters:

filenumber: The number used in the open statement when the file was opened.
variablelist: A comma-delimited list of the variables that are assigned when read from the file.

Dim MyString, MyNumber
Open "c:\TESTFILE" For Input As #1   ' Open file for input.
Do While Not EOF(1)   ' Loop until end of file.
   Input #1, MyString, MyNumber   ' Read data into two variables.
Loop
Close #1   ' Close file.