Hello:


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
my goal.

Does anybody know a piece of code that can do this?


Thanks,
Adrian T

If your data is delimited with semicolons, you can use the split function to create an array.

Darrell L. Embrey

It works!!

Thanks a bunch,
Adrian T