I have been reading the threads on the use of OPEN, GET, PUT, INPUT, APPEND etc...

I haven't found any thread that could explain the following problem.

What would be the best way to take lets say 20 text files and put them into individual spreadsheets within a workbook. The way I would have done it is to just open the file with its specific delimeters and then move it into the master workbook, but is this the most efficient.

Is there a better way by reading the text file into memory/clipboard/array and then somehow pasting into a spreadsheet.

Thanks for any help
Steve