Macro to list files containing TB within a specified date range in C:\My Documents

I have tried to write code to list files on sheet "Macro" containing "TB" in C:\My documents for eg bR1TB (Nert).xls . SouternTB.xls etc within a speciied date range in D2:E2 (Sheet Macro)


These last date modified was 07/03/2023 (format dd/mm/yyyy)

However when running the macro no files have been extracted

It would be appreciated if someone could kindly amend my code

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

Thanks for pointing out the problem

Have amended code and run macro. It now wors 100%