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?![]()
Please Login or Register to view this content.
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.
The inherent weakness of the liberal society: a too rosy view of humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks