Read data from a text file (*.txt)
My goal is to be able read data (seperated by semicolon)
from a text file (*.txt). The QueryTable object is NOT an
option because I then have to limit the number of data to
256, which is the max number of the worksheet's columns.
And I am talking about >400 data/columns in a single line (row).
If there is a way to read the data directly from a text
file (without writing it on a worksheet) and assign it to
variables/arrays in VBA, I believe that I can accomplish
Does anybody know a piece of code that can do this?