Hello,
I have hundreds of files in the same file path and I need to mass update the file name. I can create a spreadsheet of two columns, "Current Name" and "New name".
Is there a way to have excel do this for me?
Thank you,
Hello,
I have hundreds of files in the same file path and I need to mass update the file name. I can create a spreadsheet of two columns, "Current Name" and "New name".
Is there a way to have excel do this for me?
Thank you,
try the code in the post #1 https://www.excelforum.com/excel-pro...haracters.html
Assumes headers in top row, old file name in Column A, new file name in Column B
Columns A & B have file names without path but with file extensions
Change references as required.
Do you want code to output all the existing file names in the folder to Column A?![]()
Sub Or_Simply_So() Dim path As String, files, i As Long path = "C:\Folder Name Here\" '<----- Change as required files = Cells(1, 1).CurrentRegion.Value For i = 2 To UBound(files) '<----- Change 2 to 1 if no headers in top row Name path & files(i, 1) As path & files(i, 2) Next i End Sub
And what about the new names?
This might be interesting.
https://www.publicspace.net/windows/BetterFileRename/
Last edited by jolivanes; 03-20-2023 at 01:13 AM.
Experience trumps academics every day of the week and twice on Sunday.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks