Create folder macro or vb code?

's Computer Specifications

I am a novice. I need to create about two hundred folders in a specific
folder on an external drive. I have a list of the names for these folders in
an excel file. For example, Sheet1, A1 says Folder_Name, and the list of
names is in A2 thru A200. Anyone have code that will create these folders for
me?

Thanks!

's Computer Specifications

Sherri,

With that sheet active:

Sub MakeFolders()
Dim myC As Range
For Each myC In Range("A2", Cells(Rows.Count, 1).End(xlUp))
MkDir "D:\Foldername\" & myC.Value
Next myC
End Sub

HTH,
Bernie
MS Excel MVP

"Sherri" <(E-Mail Removed)> wrote in message
news:EBF2C006-3F58-4F98-AEDC-(E-Mail Removed)...
>I am a novice. I need to create about two hundred folders in a specific
> folder on an external drive. I have a list of the names for these folders in
> an excel file. For example, Sheet1, A1 says Folder_Name, and the list of
> names is in A2 thru A200. Anyone have code that will create these folders for
> me?
>
> Thanks!

's Computer Specifications

see the Create Folder message at about 15:05 today -- its the same question
already answered with slight modification

"Sherri" <(E-Mail Removed)> wrote in message
news:EBF2C006-3F58-4F98-AEDC-(E-Mail Removed)...
> I am a novice. I need to create about two hundred folders in a specific
> folder on an external drive. I have a list of the names for these folders
> in
> an excel file. For example, Sheet1, A1 says Folder_Name, and the list of
> names is in A2 thru A200. Anyone have code that will create these folders
> for
> me?
>
> Thanks!

's Computer Specifications

Wow! That worked and could not have been easier! Thanks, Bernie!!

"Bernie Deitrick" wrote:

> Sherri,
>
> With that sheet active:
>
>
> Sub MakeFolders()
> Dim myC As Range
> For Each myC In Range("A2", Cells(Rows.Count, 1).End(xlUp))
> MkDir "D:\Foldername\" & myC.Value
> Next myC
> End Sub
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Sherri" <(E-Mail Removed)> wrote in message
> news:EBF2C006-3F58-4F98-AEDC-(E-Mail Removed)...
> >I am a novice. I need to create about two hundred folders in a specific
> > folder on an external drive. I have a list of the names for these folders in
> > an excel file. For example, Sheet1, A1 says Folder_Name, and the list of
> > names is in A2 thru A200. Anyone have code that will create these folders for
> > me?
> >
> > Thanks!
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to create a new folder in my personal folder	00033000	Microsoft Outlook VBA Programming	3	4 Weeks Ago 01:02 AM
How to create a macro to incorporate the following code	Jack	Microsoft Access Form Coding	1	14th Jan 2009 11:15 PM
Macro code to create a toolbar?	Do what I can, but I''m only one man.	Microsoft Excel Misc	3	24th Oct 2008 12:08 AM
How do I Create a Macro to run VB Code in Excel?	Gator	Microsoft Excel Programming	7	8th Jan 2008 05:43 PM
How do I create a message box using macro/code?	=?Utf-8?B?dGFyemFuMTIzX3Vz?=	Microsoft Access Macros	1	14th Feb 2006 06:24 PM