Make multiple folders at one time

[Guest]

I need to make 500 new folders each September for students. I would like to
be able to make the number of new folders required with just a couple of
clicks and then just start naming them or merge the names for each folder
from a spreadsheet. I am using Office 2003.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2c0185&dg=microsoft.public.word.docmanagement

 

[Graham Mayor]

You can do this with a DOS batch file created by mail merge. Essentially you
need to create a text document that looks like

md "D:\My Documents\Test\folder1"

md "D:\My Documents\Test\folder2"

etc



with each entry on a separate line. Using a directory mail merge you can
create the list as follows



md "d:\path\{mergefield name}"



Save it as a plain text file with the name (say) folders.bat then run
folders.bat from the Windows start menu > run.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Tony Jollans]

Yes, you can do what Graham says but if you have the data in Excel it would
be far easier to either create the batch file directly from Excel - or just
create the files directly via a simple loop in some VBA code in Excel. Going
via Word just seems like a lot of effort.

If you have a list in column A (sheet1) in your worksheet, something like
this code will do it ...

For Each cel In Sheets("Sheet1").UsedRange.Columns(1).Cells
MkDir "D:\My Documents\Test\" & cel.Value
Next

(assuming "D:\My Documents\Test" already exists)

 

[Graham Mayor]

Ah, but then this is a Word newsgroup - and I know precious little about
Excel

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Tony Jollans]

This is true - well, I can't speak for your Excel knowledge but this is a
Word newsgroup, so a Word solution it has to be