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:
- Does whatever was possible in the last post ;)
- Make different folders for different file types
- Copy all the files from the specified folder
- 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
THANKS EVERYONE.
SUBHAJIT.
.
To Download the example file:
Please click this Google Drive Link
No comments:
Post a Comment