Read Data from file

To explain the Input statement is rather difficult. What you also could do is record opening the text-file in excel.

First you start the macro-recorder, and then you open the text-file.
Once you opened the text-file as you want you turn of the macro-recorder.
The VB code to open a textfile is now present as a macro.

If you want full help on this you can send the file to me with the email-link on my site.

Erik