I can create a list of all file names in a folder with this macro:
And then translate the list and use this macro to rename the files:
For more information, see the wiki Searching the Forum for Answers section.