Hi dear forum members;

I'am working on my project that will be used for renaming each .jpg file in the same directory as 100_name1.jpg, 200_name2.jpg, 300_name3.jpg ... to sort them into given order in folder.

I'm begginner at VBA coding so that i get some functions from somewhere and try to adapt my needs. So sorry for the unneccessary variable definition and so.

To do that i used the code below (the part using for this purpose only..)

Please Login or Register  to view this content.
and use this function like below :

Please Login or Register  to view this content.
This enables to write down all paths with names into C column. It is test process so that i want to see values on sheet. Then, i iterate thgrough all paths into C column than rename them via similarity algorithm (it find most similar string amongst names than rename this value according a path..) Below :

Please Login or Register  to view this content.



Whatever, it works fine until the value include the non-english characters like "ü,ö,i,ğ,ç,...etc" (For Example = ...\XML_WORKS_HOME\XML_works\RenameTest\17-oct-memphis-aktüel.jpg) Name method gives an error "File not found" When i look at the path in string it looks like " ...\XML_WORKS_HOME\XML_works\RenameTest\17-oct-memphis-aktu^el.jpg" something

So, how can i overcome this issue. I found a possible solution in this forum

Like usage :
Please Login or Register  to view this content.
But my file paths and names stored in collection than i dont know how to use this method.

Any help would be appreciated.