Importing Text Files to Excel

[1MooreMike]

Good morning -

I have 115 text, tab delimited, files I want to import into a single sheet of Excel. I found this upon searching: https://www.mrexcel.com/forum/excel-questions/8822-importing-multiple-text-files-once.html, but I want to also import the text files last modified date into a column.

Any insight?

Thanks!
Mike

 

[DanteAmor]

The macro that you put uses the Application.FileSearch function, that function no longer exists for 2007 onwards.
You need that function or you have all your files in a single folder.