Not enough columns

[Bern Muller]

I have a log file generated by another piece of software. This log file
consists of 400 numerical data points separated by tabs. I want to import
these points into Excel for further manipulation. Problem is, Excel wants to
import this data as 400 columns, and can't, being limited to 256 columns. I
have to import the data into Word, do a find/replace of the tabs to
paragraphs, and then it imports easily as 400 rows. Is there an easier way?

 

[Steve Smallman]

Have you tried reading the data using VBA, and then writing it to rows?

You will need to create a sub that uses the OPEN and READ methods, don't
forget to Close the file

Steve