Rename files with same name

[Smally]

Hello.

I've run into a small problem with my file renaming worksheet

[Attached is a smaller example version]Items - Test.xlsm

What my worksheet does is list files from into column E from directory shown in C4.

From there I choose what type of file it is to be renamed in column C.

Problem is, if in the list of files found there are two files that are similar (e.g. two driving licence files). My renaming file gives me an error 'File already exists' then ends. I'd like it to stick a (2) or (3)... at the end if there's more than one

Note1: Changing C3 will auto run list filenames macro
Note2: Change C4 to any directory you want (you may ignore sheet2)
Note3: If anyone's got a better way to achieve what I'm trying to do, feel free to suggest

[Smally]

Here's the renaming macro

Please Login or Register  to view this content.

And if you change D10 to

Please Login or Register  to view this content.

and copy down, this will add the (2), (3) ... I think, but this means the certificate/scan must be bunched together (which may not me the case)