How to batch create folders with users names Tags: Apps Last response: November 27, 2009 6:16 AM in Applications 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! Can't find your answer ? Ask ! Publish Related resources : ForumHow to create folders with numerical names 1-x ForumCreate home folders -multiple users ForumBatch file renaming based on barcode ForumOVERLY LONG FILE NAMES - as impediment to COPYING FILES ForumOVERLY-LONG FILE NAMES , as impediment to file copying ForumHow to batch create folders 1-x Forumneed to create a batch file ForumBatch file to log in using static IP with u. name and password ForumBatch File - "Access Denied" On Windows 7? ForumBatch file to get the cd drive and system drive ForumRun Batch file before Windows XP loads ForumCreate a virtual wifi router with internet on Windows 7 ForumBatch File Problem ForumBatch file to mklink directory to multiple folders ? ForumScript to create shortcuts enmasse ForumProgram that batch counts different files automatically? ForumWhat is the difference between Extended and normal version of a software? ForumHow should i cut my .mpeg format video? ForumOriginal biostar wp for biostar users ForumHow do I schedule Acronis True Image Home 11 More resources Read discussions in other Applications categories Graphics Internet Applications Multimedia Office Security CAD Distributed Computing Drivers Enterprise Software Firmware Programming Photoshop Skype Wordpress !