How to Create Multiple Folders Named According to Spreadsheet

[Guest MountainBiker]

My user needs to create 120 sub-folders on the share. The names for each are

in Excel. How can I avoid the tedium of creating each one and automate the

process?

I found at least one 3rd party app, but it's $20 and just names each folder

sequentially.

 

Thanks in advance!

[Guest Pegasus \(MVP\)]

Re: How to Create Multiple Folders Named According to Spreadsheet

 

 

"MountainBiker" <MountainBiker@discussions.microsoft.com> wrote in message

news:26F4F0E3-C040-4738-A193-AC9025AF524C@microsoft.com...

> My user needs to create 120 sub-folders on the share. The names for each

> are

> in Excel. How can I avoid the tedium of creating each one and automate the

> process?

> I found at least one 3rd party app, but it's $20 and just names each

> folder

> sequentially.

>

> Thanks in advance!

 

1. Export the folder names as text into c:\Names.txt.

2. Start a Command Prompt.

3. Type this command:

 

for /F "tokens=*" %* in (c:\Names.txt) do md "S:\%*"

 

It might be a good idea to populate c:\Names.txt with

only two or three entries until you have convinced yourself

that the command does exactly what you expect it to do.

[Guest MountainBiker]

Re: How to Create Multiple Folders Named According to Spreadsheet

 

Thanks, I'll definitely test it first lest I consume the entire volume with a

million empty folders.

 

I figured out another way using a batch file:

 

@echo off

md "C:\error\New Folder\New Folder2\New Folder3\test 1"

md "C:\error\New Folder\New Folder2\New Folder3\test 2"

md "C:\error\New Folder\New Folder2\New Folder3\test 3"

 

If mine doesn't work I'll give yours a shot.

 

Thanks!

 

"Pegasus (MVP)" wrote:

>

> "MountainBiker" <MountainBiker@discussions.microsoft.com> wrote in message

> news:26F4F0E3-C040-4738-A193-AC9025AF524C@microsoft.com...

> > My user needs to create 120 sub-folders on the share. The names for each

> > are

> > in Excel. How can I avoid the tedium of creating each one and automate the

> > process?

> > I found at least one 3rd party app, but it's $20 and just names each

> > folder

> > sequentially.

> >

> > Thanks in advance!

>

> 1. Export the folder names as text into c:\Names.txt.

> 2. Start a Command Prompt.

> 3. Type this command:

>

> for /F "tokens=*" %* in (c:\Names.txt) do md "S:\%*"

>

> It might be a good idea to populate c:\Names.txt with

> only two or three entries until you have convinced yourself

> that the command does exactly what you expect it to do.

>

>

>

[Guest Pegasus \(MVP\)]

Re: How to Create Multiple Folders Named According to Spreadsheet

 

You can certainly do it your way, as long as you don't mind

populating your batch file manually with the various folder

names.

 

 

"MountainBiker" <MountainBiker@discussions.microsoft.com> wrote in message

news:81D9CEC6-DC53-4DDF-9640-63C966BE0687@microsoft.com...

> Thanks, I'll definitely test it first lest I consume the entire volume

> with a

> million empty folders.

>

> I figured out another way using a batch file:

>

> @echo off

> md "C:\error\New Folder\New Folder2\New Folder3\test 1"

> md "C:\error\New Folder\New Folder2\New Folder3\test 2"

> md "C:\error\New Folder\New Folder2\New Folder3\test 3"

>

> If mine doesn't work I'll give yours a shot.

>

> Thanks!

>

> "Pegasus (MVP)" wrote:

>

>>

>> "MountainBiker" <MountainBiker@discussions.microsoft.com> wrote in

>> message

>> news:26F4F0E3-C040-4738-A193-AC9025AF524C@microsoft.com...

>> > My user needs to create 120 sub-folders on the share. The names for

>> > each

>> > are

>> > in Excel. How can I avoid the tedium of creating each one and automate

>> > the

>> > process?

>> > I found at least one 3rd party app, but it's $20 and just names each

>> > folder

>> > sequentially.

>> >

>> > Thanks in advance!

>>

>> 1. Export the folder names as text into c:\Names.txt.

>> 2. Start a Command Prompt.

>> 3. Type this command:

>>

>> for /F "tokens=*" %* in (c:\Names.txt) do md "S:\%*"

>>

>> It might be a good idea to populate c:\Names.txt with

>> only two or three entries until you have convinced yourself

>> that the command does exactly what you expect it to do.

>>

>>

>>