Hi
I have up to 100 .txt file in a folder each containing one line of
text in a pipe delimited format. Each line of text contains the same
number of data items and once delimited to Excel contains the same
data type in each column. I would like to iterate throught each file
in the folder and be able to import each line of text to the same
sheet in Excel each line being imported to its own row. Can anyone
give me a clue as how I would go about this using VBA. Thanks all...
Mike