Renaming files based off excel spreadsheet

[glukemey]

I apologize as I'm a VBA novice here, but been using the code from the thread below to auto rename files in a specified folder. The content of the files and amount of files are changing as new projects arise, but all old file names follow the same format. The new names do change based off the new project as well. It worked a few times after running a recent update to Microsoft Office I receive the error below when running the code.

"Run-time error '53':

File not found"

Been looking through the code and cannot determine what exactly the issue is, but the debugger says it is this line: Name myPath & "\" & oldName As myPath & "\" & newName

Does anyone know what my issue is?

rename files based on excel spreadsheet

I have 500 .avi files that I need to rename. The files are titled, for example, 2345678.avi. In an Excel spreadsheet I have 2 columns of data. In column A is the current filename, 2345678.avi. In the corresponding cell in column B I have the actual filename that I want to rename the file to...

www.mrexcel.com

 

[pinkAttitude]

I'm using this same code.
When it hits newName in the Do loop, I'm getting Run-time error '9': Subscript out of range

It's my first time using VBA. Hoping to find help here, also.