Macro to extract list of CSV files containing TB in C:\sales

[Howardc1001]

I am looking for code to list all CSV files that contains TB in C:\sales for eg BR1TB Jan-23.csv, BR2TB Jan-23.csv, SouthernTB Jan-23.csv etc

Your assistance in this regard is most appreciated

[ByteMarks]

Does this work for you?

Please Login or Register  to view this content.

[Howardc1001]

Many thanks for the help. Your code works 100%