Hey guys. I've done some snooping around to find the solution to my particular problem, but don't know enough about using VBA outside of Excel to figure it out with what I've found. Here's what I want to happen:
I want all files with the extension .pdf, .doc, .zip, and .7z to be copied from a large group of subfolders and pasted into one folder. Most of these files will begin with an 8-digit ID that represents a name. I would like all files that begin with this 8-digit ID to have that ID replaced with the name that corresponds to it found within the spreadsheet.
In the spreadsheet, let's say the 8-digit IDs are A:A and the names are B:B. The folder that contains all subfolders will be C:/Sourcefolder and the destination folder will be C:/Destinationfolder.
How would I do this?
Here are the things I've found so far that are very close.
excel - Cycle through sub-folders and files in a user-specified root directory - Stack Overflow
excel vba - copying files from multiple subfolders using vba - Stack Overflow
Move files to another folder by VBA
Copy and Move files and folders
Thank you guys in advance for your help. I had a hard time following some of the code found at these sources, but I tend to understand the stuff I find here.
I want all files with the extension .pdf, .doc, .zip, and .7z to be copied from a large group of subfolders and pasted into one folder. Most of these files will begin with an 8-digit ID that represents a name. I would like all files that begin with this 8-digit ID to have that ID replaced with the name that corresponds to it found within the spreadsheet.
In the spreadsheet, let's say the 8-digit IDs are A:A and the names are B:B. The folder that contains all subfolders will be C:/Sourcefolder and the destination folder will be C:/Destinationfolder.
How would I do this?
Here are the things I've found so far that are very close.
excel - Cycle through sub-folders and files in a user-specified root directory - Stack Overflow
excel vba - copying files from multiple subfolders using vba - Stack Overflow
Move files to another folder by VBA
Copy and Move files and folders
Thank you guys in advance for your help. I had a hard time following some of the code found at these sources, but I tend to understand the stuff I find here.
