Hello all!
Today, again I am going to post this one to address one of the tedious task that I got at my workplace. The task was quite simple. We need to create folder structures for test cases and we all know what can be the number of test cases.
It was required to created a folder hierarchy using a specific naming convention as per predefined data in test case preparation. Now if it was couple of folders, it would have been easier to create manually. BUT, it was too many number of folder and with nested hirarchy.
Hence the idea of this post!
What I did was quite simple, I just extended the existing EXCEL sheet where the data was already present and created a macro which takes the data as input and creates the folder hierarchy as per that.
The data is very simple – a Row containing the folder hierarchy like: Folder1, Folder1\Folder2, Folder1\Folder2\Folder3, folder4 and so on..
The macro works on this and creates the necessary folder structure automatically. Below is the code for the same.
You can also download the fully function macro enabled excel sheet and start creating folders automatically from HERE.