How to batch create folders with users names Tags: Apps Last response: November 27, 2009 6:16 AM in Apps General Discussion Share ntadmin101 November 13, 2009 2:32:00 PM In an earlier post How to batch create folders 1-x I showed how you can easily create a whole bunch of folders with numbers as the folder names using a batch file. In this post I'll show you how to do this using usernames or some other data (provided that the data doesn't break the folder naming convention in Windows.) Again we're going to use excel and create a batch file. You should have an excel document with your users names in a single column In my example all of the user names will be populated in column B Click into cell 1 of column A and type c:\folder\ Hit enter and you will be dropped down to the next cell. -Single click on Cell 1 in Column A and notice the little black square at the bottom right of the cell -Click and hold on that square and drag it down as far as you need, or to where the names end in the parallel Column B. You should now see that all the cells in column A have C:\folder\ in them Time to concatenate Hopefully column C is empty if not pick another column. My example uses Column C. Click Cell A in column C then click into the formula bar and type CONCATENATE(A1 & B1) Then hit enter You should now see that cell A of column C has c:\folder\(username from Cell A of column B) Click and hold on the little black box on Cell A Column C and drag down as far as you need to. Highlight and copy column C's data. Now we create the batch file Click start, run and type notepad paste your data into the notepad document and then save it as MakeFolders.bat Windows will warn you about the file name change, just accept it. Before you run the new batch file, check the root of C to make sure you don't have a existing folder named "folder" That's pretty much it. Note:You can tweak the paths in the batch file as needed. I hope this helps somebody out. More about : batch create folders users names r_manic November 27, 2009 6:16:47 AM Thanks for sharing man! m 0 l Can't find your answer ? Ask ! Publish Related resources How to create folders with numerical names 1-x Forum User folders - how to change names Forum Import Names from Excel to create new Folders XP Forum How can i create a Password and user name of my wireless Forum How to create a batch file for removing one Entry in a registry key Forum SolvedHow to restrict users from accessing shared folders Forum Preventing users from taking away permissions of folders they create Forum How to create batch file to install reg file Forum Create home folders-multiple users Forum folders lost after creating restricted user acct. How to f.. Forum I am on windows 8 and I want to install a mod for game dev tycoon and the only thing I know about folders is how to create the Forum BAtch file to copy contents of folder created today to another folder without dos tree Forum How to change all domain names' IP in one batch Forum SolvedHow do i create an email if i own the domain name ? Forum How To Share Folders With All Users On a Single Computer Forum How to create an association in the folders options control panel to have a prog Forum Troubles with moving, creating and naming folders Forum user added to permission list when they create a folder? Forum How to flash a bios creating auto batch file and flash the bios? Forum Create Shared Folders With Domain User Rights Forum More resources !