Folders

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 25 Sep 2004 07:13 GMT

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

Reply to this Message

Nick Hodge - 25 Sep 2004 09:18 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> The escenario is as follows; I have a list of over 400 individuals on
> excel
[quoted text clipped - 9 lines]
> thanks
> Samuel

Reply to this Message