Finding Txt in subfolders

Hi all,

I am trying to open txt files to pull into my workbook. I have code that works fine if all the text files are in the same folder. I was thinking of writing code to copy them over however I wondered if there was a more elegant way to do it.

I would like to search all sub folders but am up for naming them. I have (unsuccessfully) written a few things that nearly do it but they all fall over.

Please Login or Register  to view this content.