Windows 2003 How to Create Multiple Folders Named According to Spreadsheet

[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!

 

[Pegasus \(MVP\)]

"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.

 

[MountainBiker]

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.
>
>
>

 

[Pegasus \(MVP\)]

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.
>>
>>
>>