{"id":4788,"date":"2016-11-28T06:36:36","date_gmt":"2016-11-28T06:36:36","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4788"},"modified":"2017-10-17T21:22:59","modified_gmt":"2017-10-17T21:22:59","slug":"excel-tool-folder-structure-creator","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/","title":{"rendered":"Excel Tool : Folder Structure Creator"},"content":{"rendered":"

Dear readers,
\nIn my previous article I posted an article about how to create folder in windows by Excel VBA code.<\/a> That triggers me to build an Excel tool to create a hierarchical or Tree folder structure in any directory which is defined by you in excel sheet. Before I built this tool, I was thinking what is TOP 3<\/strong> problem is it going to solve of my readers and here are the answers:<\/p>\n

<\/p>\n

1. Creating folder structure in No time<\/h2>\n

No matter how complex and how deep folder structure is, it will get created in seconds. To create folder structure, click on the “Create Now>>” button to do so.<\/p>\n

<\/p>\n

Replicate any existing folder structure<\/h3>\n

Suppose you want to replicate an existing folder structure in your PC. So to do this, you can even copy the root folder and paste it – but there is a major disadvantage of this method. You are copying the files as well with the folder structure. You need to delete them all manually – which is a very time consuming and boring task. Using this tool you can simply read any existing folder structure and then by modifying the first root folder name, you can click on “Create Now>>” and folder structure is replicated without copying any content of the folder structure.<\/p>\n

<\/p>\n

Define your own Folder structure templates<\/h2>\n

In big organizations when folder structure is left to individual choice then it becomes really messy as every one will try to organize the structure in a way they like. At the end each one of us are forced to browse each and every folder to find your document, which is not efficient. Therefore, it is a good practice to maintain a common folder structure across organization for each projects.
\nIn such case all you can define your folder structure according to your need and save them as a template. Here on whenever there is new project, you can select that template and create the same folder structure for the new project.<\/p>\n

Rules to Define Folder Structure here in Excel<\/h3>\n

Mainly there are 3 rules:
\n1. Your first Root Node should start from Range B10<\/strong> as highlighted in the above picture as point no 9<\/strong>
\n2. Any of the child node can not be stated in the same row in next column.
\n3. Any of the row should not be blank.<\/p>\n

How to use the tool<\/h1>\n

1 and 2. Main Folder Path and Browse button<\/h2>\n

This is path where you want to create your folder structure. This path can be typed manually or it can be selected by clicking on Browse button.<\/p>\n

3 and 4. Existing Templates drop down and Load template<\/h2>\n

As explained above, in this tool you can define your own template. As soon as you have defined your template, you can see the name your new template in this drop down. After selecting the drop down, you need to click on Load Template button in order to display your defined structure.<\/p>\n

5. Validate button<\/h2>\n

Validate button checks if all these 3 rules are satisfied in your defined structure or not. Unless these rules are met, it will not allow you to create your folder structure.<\/p>\n

6. List existing Structure<\/h2>\n

By clicking on this button you can get the folder structure which is there at your given main folder path<\/strong>. Once your structure is loaded here in this sheet, now you can provide a different folder path and click on Create Now >> <\/strong> to create \/ replicate the same folder structure.<\/p>\n

7. Create Now >><\/h2>\n

As the name suggests, this is button which does the magic of creation of the defined folder structure.<\/p>\n

8. Messages<\/h2>\n

In this field you will see all the messages\/errors which occurs during any of the above operations.<\/p>\n

9 and 10 – Labels header and First Node<\/h2>\n

Row 9 is defined to have the level headers and Cell B10 (name range= startRange) is the starting point where your first node should be specified.<\/p>\n

How to define a new template<\/h3>\n

Steps are defined and explained in the Excel workbook itself in the template sheet. Kindly read them before adding any new template.<\/p>\n

\"Folder<\/a>

Folder Structure Template<\/p><\/div>\n

About the VBA code used behind each buttons<\/h1>\n

I will try to explain about the VBA code which I have used to create this tool in my next article. Meanwhile you can read my previous article<\/a> where I had explained how to list all the folders and sub folders from a given path. In fact I am calling the same function on clicking on List existing Structure<\/strong> button. see you till my next article and don’t forget to download this workbook \ud83d\ude42<\/p>\n

FREE Download<\/h2>\n

Here is your FREE copy of the Folder Structure creator excel tool. Download this, use it and do not forget to provide me your thoughts on it by typing your comment here or sending en email or you can twit me <\/a> You can also share it with your friends colleagues and most importantly your Boss \ud83d\ude00
\n
\n\"Download
\n<\/a><\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

Dear readers, In my previous article I posted an article about how to create folder in windows by Excel VBA code. That triggers me to build an Excel tool to create a hierarchical or Tree folder structure in any directory which is defined by you in excel sheet. Before I built this tool, I was […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1678,1682],"tags":[],"class_list":["post-4788","post","type-post","status-publish","format-standard","hentry","category-macro","category-interesting-vba-functions","category-popular-articles"],"yoast_head":"\nFolder Structure Creator - A FREE Excel VBA Tool<\/title>\n<meta name=\"description\" content=\"Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tool : Folder Structure Creator\" \/>\n<meta property=\"og:description\" content=\"Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-28T06:36:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-10-17T21:22:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Tool : Folder Structure Creator\",\"datePublished\":\"2016-11-28T06:36:36+00:00\",\"dateModified\":\"2017-10-17T21:22:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\"},\"wordCount\":833,\"commentCount\":15,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png\",\"articleSection\":[\"Excel Macro\",\"Interesting VBA Functions\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\",\"name\":\"Folder Structure Creator - A FREE Excel VBA Tool\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png\",\"datePublished\":\"2016-11-28T06:36:36+00:00\",\"dateModified\":\"2017-10-17T21:22:59+00:00\",\"description\":\"Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Tool : Folder Structure Creator\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Folder Structure Creator - A FREE Excel VBA Tool","description":"Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tool : Folder Structure Creator","og_description":"Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.","og_url":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2016-11-28T06:36:36+00:00","article_modified_time":"2017-10-17T21:22:59+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Tool : Folder Structure Creator","datePublished":"2016-11-28T06:36:36+00:00","dateModified":"2017-10-17T21:22:59+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/"},"wordCount":833,"commentCount":15,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png","articleSection":["Excel Macro","Interesting VBA Functions","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/","url":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/","name":"Folder Structure Creator - A FREE Excel VBA Tool","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png","datePublished":"2016-11-28T06:36:36+00:00","dateModified":"2017-10-17T21:22:59+00:00","description":"Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/11\/FolderCreator.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2016\/11\/excel-tool-folder-structure-creator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Excel Tool : Folder Structure Creator"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4788"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4788"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4788\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}