Total Pageviews

Wednesday, July 6, 2016

Exploring The File System Object_Part 2

In my previous post I explored the few  methods of the fileSystemObject to find all the Sub Folders in a parent folder. Count of all files in them, their size and filetypes.
In this post I have used few more methods to build a macro which will do the following:
  1. Does whatever was possible in the last post ;) 
  2. Make different folders for different file types
  3. Copy all the files from the specified folder
  4. Organize the similar file types into their respective folders


This is how the excel file looks,







This is the main() subroutine which calls the organize routine,












This is the routine that organizes different file types into different folders






This is the initial and final output folders:























Please put your thoughts and comments below so that I can improve.

THANKS EVERYONE.
SUBHAJIT.
.
To Download the example file:
Please click this Google Drive Link

No comments: