In this Excel video tutorial, we gonna see How to Create Multiple Folders and Subfolders using Excel and NotePad to help us save time and Automate Tasks. Create Many folders with a batch file or .bat and Microsoft Excel.
The notepad file is an executable file and will help us automate tasks and create several folders at once, create all the folders we need with just one click. Each folder we will create must have a command called MD and all the subcategories or subfolder, need the CD command and directory and the MD command. We need to append with the ampersand & those commands togethers, the concatenate function can help us too.
Excel can help us create the lists of folders we need to create and also the lists of subfolders. Let's say you need to create a folder for each month of the year. In other words, you will need to manually create 12 folders. But to avoid doing this work manually, you can automate this task with Excel. You can create this list within Excel and with the help Notepad creates all folders automatically.
If you need to create subfolders for each folder you have i.e. multiple subfolders for multiple folders you can also automate this task using Excel and run the code with Notepad.
#JopaExcel #Dashboard #Excel