How can I create five folders after this with a spacific name

's Computer Specifications

MkDir "C:\" & Range("C3").Value

Example: C:\12345\ART, LG1, G-CODE, LG3, LR2

's Computer Specifications

Sub tryme()
For Each mycell In Range("C3:C6")
MkDir "C:\" & mycell.Value
Next
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"David Shoemaker" <(E-Mail Removed)> wrote in
message news:3A3ABDA1-5D56-491A-B2FD-(E-Mail Removed)...
> MkDir "C:\" & Range("C3").Value
>
> Example: C:\12345\ART, LG1, G-CODE, LG3, LR2

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filtering spacific contacts into certain groups	=?Utf-8?B?TWFya3N0ZXIzOTEw?=	Windows Vista Mail	2	24th Aug 2010 03:00 AM
Making a row coloured if spacific data is anywhere in it	DJ MC	Microsoft Excel Programming	1	5th Sep 2007 09:13 PM
spacific time	jbarna@webermarking.com	Microsoft Access	2	26th Aug 2007 08:37 AM
how do i get a pop up with reminders of things to do at spacific .	=?Utf-8?B?YWJjIGFuc3dlcmluZyBzZXJ2aWNl?=	Microsoft Excel Misc	2	27th Dec 2005 05:31 PM
Deleting Spacific records	Oded Kovach	Microsoft Access Queries	3	5th Dec 2004 09:05 PM