Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bulk Folder Creation

Status
Not open for further replies.

micon55

MIS
Joined
Feb 22, 2001
Messages
74
Location
GB
Does anyone know how to bulk create folders with different names.
Is it possible to have a comma delimited text file and then run a utility to create these folders? Has anyone ever tried to do this?

Many Thanks in advance
Mike
 
You can use Excel to create a batch file to make the directories. Here's what you do:

Column A: MD<space> (space = &quot; &quot;)
Column B: your new folder name
Column C: =concatenate(A1,B1)

Copy column C to a new worksheet and save it as a text file with an extention of .BAT, but do not give it a name of an existing Windows program (i.e. MD.BAT)

Run the new .BAT file to create the directories
 
Thanks a million. I'll give it a try.
M
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top