VBA Input Statement

Input Description

Returns the open stream of an Input or Binary file (String).

Input Syntax

Input(Number, [#]FileNumber)

The Input statement contains 2 arguments:

Number: The number of characters to return.

FileNumber: Valid file number.

Examples of Excel VBA Input Statement

To test the 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.

abc
1 2 3
xy z

Please run the following code.

Sub Input_Fx_Example()
    Dim strContent As String
    Dim MyChar
    Open "D:\test.txt" For Input As #1    ' Open file.
    Do While Not EOF(1)    ' Loop until end of file.
        MyChar = Input(1, #1)    ' Get one character.
        strContent = strContent & MyChar '
    Loop
    MsgBox strContent
    Close #1    ' Close file.
End Sub

Then, the result will be as following.