VBA Input Statement
Written by
Reviewed by
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.
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!