Sunday, 12 August 2012

Move Files To Subfolders

Three days ago, a blog reader asked me to help him with the following problem: He has a significant amount of word files in a folder and he wanted to automatically create subfolders and move a specific amount of files (40) in each subfolder. After finishing the necessary VBA code, I decided to expand the code a little bit and I ended up with a more generic application. So, with this application you can create custom subfolders (with a name you define) that contain a predefined number of files. You can group either files with a specific extension (doc, pdf, xls etc.), or all the files that are contained in the main folder. 

How to use it

The following short videos demonstrate the application in use.

A) Grouping all files in subfolders.

B) Grouping files with a specific extension to subfolders.

Download it from here

This file can be opened with Office 2007 or newer.
Please, remember to enable macros before using it.

Read also

Did you like this post? If yes, then share it with your friends. Thank you!


Mechanical Engineer (Ph.D. cand.), M.Sc. Cranfield University, Dipl.-Ing. Aristotle University, Thessaloniki - Greece.
Communication: e-mail, Facebook, Twitter, Google+ and Linkedin. More info