Copy and rename files without overwriting files

Hello,

I need some help to adjust this code found on the internet.

I would like that whenever I run the code, new files on the destination folder are never overwritten. The solution seems easy, but I tried a lot and I'm inexperienced in VBA. Please help me.

File attached.

Thank you.

Please Login or Register  to view this content.

Do a google search, "If File Exists excel vba" , there will be lots of results.
Whatever you use would then be able to use into your code, so if the file exists, then do nothing, if it doesn't exist, then do something.