Thanks Leith, that code would be just the sort of the I could put into my macro,
Unfortunately I seem to be struggling to get it to work,
I realised the date format of the file title can't have the / symbol in it, so the files are in time_yymmdd.txt format instead. I altered your code slightly to account for this.
As I understand it if I have the following 3 files in the directory C:\test\
1215_100609.txt
1109_100722.txt
1845_090420.txt
then these 3 titles should be entered into cells A1, A2, A3 of sheet 1?
I ran the slightly altered below code but nothing appeared.
Do you have any suggestions to what I might have done wrong?
Bookmarks