rey06
01-04-2022, 11:57 AM
Hello,
I have a macro that will create subfolders at a specified location. There were a couple hundred today that were named incorrectly. I've found some code that is said to delete folders specified in a certain column (like I put the file paths in column A that I want deleted) but nothing is working. I'd like to either rename these somehow or delete them. It's really not the end of the world - the folder was named "old folders" instead of "old files" but I'd still like to correct.
I'm wondering if there is an easy way to use a macro to do this? Almost like a find and replace, like have current name in column A, desired name in column B, or just a delete the folders noted in column A? Re-creating these is no problem as I can do it in seconds with the current macro.
I know there are existing answers for this, and I've tried several different methods and nothing is working.
TIA!
R
I have a macro that will create subfolders at a specified location. There were a couple hundred today that were named incorrectly. I've found some code that is said to delete folders specified in a certain column (like I put the file paths in column A that I want deleted) but nothing is working. I'd like to either rename these somehow or delete them. It's really not the end of the world - the folder was named "old folders" instead of "old files" but I'd still like to correct.
I'm wondering if there is an easy way to use a macro to do this? Almost like a find and replace, like have current name in column A, desired name in column B, or just a delete the folders noted in column A? Re-creating these is no problem as I can do it in seconds with the current macro.
I know there are existing answers for this, and I've tried several different methods and nothing is working.
TIA!
R