Input # Statement

Description

Reads data from an open sequential file and assigns the data to variables.

Syntax

Input #filenumber,varlist

The Input # statement syntax has these parts:

Part	Description

filenumber	Any valid file number.
varlist	Comma-delimited list of variables that are assigned values read from the file: can't be an array or object variable. However, variables that describe an element of an array or user-defined type may be used.

Remarks

When read, standard string or numeric data is assigned to variables as is. The following table illustrates how other input data is treated:

Data	Value assigned to variable

Delimiting comma or blank line	Empty.
#NULL#	Null.
#TRUE# or #FALSE#	True or False.
#yyyy-mm-dd hh:mm:ss#	The date and/or time represented by the expression.
#ERROR errornumber#	errornumber (variable is a Variant tagged as an error).

Double quotation marks (") within input data are ignored.

Data items in a file must appear in the same order as the variables in varlist and be matched with variables of the same data type. If a variable is numeric and the data is not, zero is assigned to the variable.

If the end of the file is reached while a data item is being input, the input is terminated and an error occurs.

Note

In order to correctly read data from a file into variables, you should always use the Write # statement instead of the Print # statement to write the data to the files. Using Write # ensures that each separate data field is properly delimited.

See Also

Input Function, Write # Statement.

Example

This example uses the Input # statement to read data from a file into two variables. For purposes of this example, assume that TESTFILE is a file with a few lines of data written to it using the Write # statement; that is, each line contains a string in quotations and a number separated by a comma, for example, ("Hello", 234).

Open "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 variables.
    Debug.Print MyString, MyNumber    ' Print data to Debug window.
Loop
Close #1    ' Close file.