Importing multiple txt files

[Eduards]

Hi All,

I have a blank excel sheet and multiple .txt files to be imported into every sheet.

I'd like each file to be imported into a new sheet inside one workbook

I will have approximately 40 .txt files to be imported

How can this be done without selecting data and importing data for each individual .txt file. Instead import all selected .txt files and import all at once?

Thanks,

Eduards

[Eduards]

I have found a solution:

Please Login or Register  to view this content.