Folders

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Back
Top