Rename files in a single folder based on the modified date and words for each file

Something along these lines, maybe.

Please Login or Register  to view this content.

thanks it works as I expected, but there is problem when there are files names have already renamed containing dd mmm yyyy , then will continue add dd mmm yyyy
should just rename for doesn't contain dd mmm yyyy . could you fix it ,please?

Please try it like this.

Please Login or Register  to view this content.

unfortunately still add dd mmm yyyy continuously when run the macro every time

unfortunately still add dd mmm yyyy continuously when run the macro every time

Not sure.
If it test it on a file Test Sales Reports.txt
Running the first time changes it to Test Sales Reports 08 MAR 2023.txt
Subsequent runs have no effect.

You could try using this line which looks for the date anywhere in the file name.

Please Login or Register  to view this content.

still the same problem.
did you test with EXCEL files?

Yes, on a mix of file types.
Is it possible to post an actual file name?

OK
BTW: you have typo should not reports , should be report .
any way I modified based on your code.

Thanks for pointing that out. I don't think it's related to your issue though, as "reports" would have meant that files with "report" would have been over looked.
I'm still not getting the date added more than once.

I don't think it's related to your issue though, as "reports" would have meant that files with "report" would have been over looked.

yes that's correct ,but if the others members especially the beginners read OP ,then your code doesn't work .

I'm still not getting the date added more than once.

I'm still lost why does that for me !