+ Reply to Thread
Results 1 to 8 of 8

VBA Help - Creating Folders and Subfolders in Windows Explorer

  1. #1
    Registered User
    Join Date
    02-19-2021
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2016
    Posts
    11

    Question VBA Help - Creating Folders and Subfolders in Windows Explorer

    Hey

    Please bear with me, I am a complete novice and very much in awe with the information I have already received from browsing the posts on this forum.

    Whilst I have had some progress, I don't seem to be able to find exactly what I am looking for and am hoping that someone will be able to help me.

    I have two lists in Excel, the first column (column A) contains the names of all employees (around 400), column B contains a list of 12 values (subfolder names).

    I really want to be able to generate parent folders with the values of column A and, within these, have all 12 subfolders with the values in column B within each of the parent folders.

    So far I have been able to create all the parent folders but without the 12 subfolders - I am happy to either delete them all again and start from scratch or apply a macro which will add the subfolders to the current parent folders.

    Any ideas? Any help will be so gratefully received!

    Thank you
    Last edited by jodoy19; 02-19-2021 at 03:52 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    Please share a desensitized sample sheet as per the yellow banner above so we can assist further.

  3. #3
    Registered User
    Join Date
    02-19-2021
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2016
    Posts
    11

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    Hi - sorry, my mistake. I got far too ahead of myself.

    Please find attached
    Last edited by jodoy19; 02-19-2021 at 03:13 PM.

  4. #4
    Registered User
    Join Date
    02-19-2021
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2016
    Posts
    11

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    Sorry - I attached wrong file and cannot see how to delete post. Will post again shortly

  5. #5
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    Here is code that can create folders and subfolders.

    Please Login or Register  to view this content.
    Last edited by maniacb; 02-19-2021 at 03:31 PM.

  6. #6
    Registered User
    Join Date
    02-19-2021
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2016
    Posts
    11

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    I cannot thank you enough.

    Apologies I uploaded the incorrect file earlier. And even despite this you were so helpful and wonderful.

    It has worked perfectly and I am very grateful.

    I really hope you have a great weekend

  7. #7
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  8. #8
    Registered User
    Join Date
    02-19-2021
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2016
    Posts
    11

    Re: VBA Help - Creating Folders and Subfolders in Windows Explorer

    Done all of the above - thanks again! Amazing!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating Folders and Subfolders based off Column A and B
    By Sdthaman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-12-2015, 06:41 PM
  2. [SOLVED] creating folders and subfolders
    By Lohara005 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2015, 07:28 AM
  3. Create folders in all the subfolders and move subfolders
    By Amarjeet Singh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2015, 12:51 PM
  4. creating folders and subfolders using macros
    By mikmez in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 08:45 PM
  5. [SOLVED] Creating Folders and Subfolders
    By matt1133 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2013, 03:52 AM
  6. Opening Windows Explorer with all folders compressed
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2009, 08:34 PM
  7. Creating folders and subfolders from excel file list
    By afaubert in forum Excel General
    Replies: 4
    Last Post: 11-08-2005, 07:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1