Not enough columns

  • Thread starter Thread starter Bern Muller
  • Start date Start date
B

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?
 
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
 
Back
Top