Using Excel to create multiple Folders with subfolders
Posted on 2011-03-03
One of my users has requested that I create a new directory for them, the directory will consist of one parent Folder with mulitple subfolders, these subfolders will then also have subfolders.
The user was kind even to send a list of all folders needed to me on a Excel spreadsheet.
The problem is, this directory consists of over 300 folders, each with its own unique name adn as you can imagine, it will take rather long to create.
Is there a way to do this via a formula?
Column A contains the command mkdir, column B contains the first folder to be created and column the second folder and so on. Thus far I have been able to use a "formula" to create the first folder, the formula looks as follows: =A3 & B3 the out put of this was: mkdir Folder 1
Cell A contained the command mkdir and cell B contained the name of the first folder... Folder 1.
How can I expand on this to create all required subfolders and their subfolders?
Thanks in advance