Folders

[Guest]

The escenario is as follows; I have a list of over 400 individuals on excel
file. I need to create separate folder for each individual. the question is,
is there any way this can be done simultaneously instead of create each one
at a time?

I will appreciated your help, this will save me alot of time, if it's
possible of course!

thanks
Samuel

 

[Nick Hodge]

Sam

You could run this macro after you have selected the names. It will create
folders, as written, in the root drive (C:\), but you could change that

Sub CreateFolders()
Dim myCell As Range
On Error Resume Next
For Each myCell In Selection
MkDir ("C:\" & myCell.Value)
Next myCell
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)