Excel-Importing a Tab delimited file usig VBA
Posted on 2003-03-18
I have a Tab delimited file and I want to bring it into my excel doc filling sheet1 with the data in the file. I plan on putting the data into an array and then filling each cell with the array one line at a time. For example..I would put the data from line 1 into an array, then fill the first row of sheet1 with the values in the array, then clear the array and do the same for the second line and so on. But I'm unsure of how to read the Tab delimited file into Excel. Any help would be greatly appreciated. Thank you in advance.