read txt files n transfer to xls.
View Single Post
I'm not sure whether that can be done, unless the text file was originally created by saving a table through excel as a text file.
You'll have to use code to read a text file. Something like this:
open textfile1.txt for input as #1