software

I am a yearbook advisor and would like to be able to create individual
folders for students (seniors), for whom we must scan pictures, without
creating them one at a time. Is there a way to export a list of names into
Windows Explorer to create a folder for each student?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

Here's a quick macro - no error checking - that creates a subdir for each
student in the selected range of an Excel sheet

Sub md()
Const strPath = quot;C:\Students\quot;
Dim cc As Range

For Each cc In Selection
MkDir strPath amp; cc.Text
Next

End Sub

For information on installing the code see
Getting Started with Macros and User Defined Functions

www.mvps.org/dmcritchie/excel/getstarted.htm
quot;krickettsquot; wrote:

gt; I am a yearbook advisor and would like to be able to create individual
gt; folders for students (seniors), for whom we must scan pictures, without
gt; creating them one at a time. Is there a way to export a list of names into
gt; Windows Explorer to create a folder for each student?
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions