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