Formula to rename files in a folder

[SimonR]

Hi,

Following my thread Using Excel VBA to rename files in a folder asking how to rename files in a folder using VBA, I am trying to do something similar but the procedure is more complicated.

In the other scenario I simply needed to attach the same prefix to the first 11 characters of the file name. In this case, however, the file name starts with a number which can be any size up to five digits, preceded by an underscore. I need to attach the same prefix "abcde123 " to the number to get the renamed file.

In regular Excel terms, the new file name would be created by the formula ="abcde123 "&left(a1, find("_",a1)-1). How would I use VBA to change the file name (sFileName as in the other thread) the same way?

 

[Kerryx]

wouldn't a tool like Bulk Rename Utility do this for you?

 

[SimonR]

With respect that's not really helpful and it seems you haven't fully read both this thread and the one I linked to. I already have the VBA code I need to rename files thanks to Joe4's assistance in the other thread, I just need to tweak it so that all the files are renamed in the way I described above. Also it's a useful means of improving my knowledge of VBA.