Buy Dideo Subscription
Get the code here https://www.bluepecantraining.com/excel-vba-organise-files-into_subfolders-file-type/ This video demonstrates how to write the VBA code that will organise files into subfolders by file type. The code will do the following: 1) Prompt the user to select a folder to organise 2) Create a new folder to copy the files to in the same parent folder as the original folder 3) Loop through each file in the original folder 4) Create a sub-folder for each file type (making sure the folder doesn't already exist) 5) Copy files to the correct sub-folder 5) Delete the original folder The subprocedure uses the FileSystemObject ------------------------
