+ Reply to Thread
Results 1 to 2 of 2

Export Excel List to Empty Folder List

  1. 11-14-2012, 02:38 PM #1
    RickyP33
    RickyP33 is offline
    Registered User
    Join Date
    11-14-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Export Excel List to Empty Folder List

    Hello Everyone. I have a question about Excel that I'm not sure is even possible. But if it is possible it can turn several weeks of work into just a few seconds!

    I have to create thousands upon thousands of folders containing certain data. Each folder will have a certain name, and each name I currently have listed in an Excel file. Instead of manually creating & naming each individual folder, I would like to be able to export my list in Excel, to general a list of empty folders, with the names corresponding to my Excel list.

    Is this possible?? If so, it would save me a ton of time if there is a way to do this. Thanks!!

    -Rick
    Reply With QuoteRegister To Reply
  2. 11-14-2012, 02:42 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Export Excel List to Empty Folder List

    'MAKE FOLDERS AND SUBFOLDERS

    Here's a macro for creating all the folders and subfolders in a string path. There's a macro and a UDF version that other macros can use.


    Make Folders and Subfolders



    For instance, it can take this string:

    C:\Main\Sub1\Sub2\Testing\Customer1

    ...and it will create every folder from the top down, all from the one string.
    Last edited by JBeaucaire; 12-27-2019 at 10:36 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1