creating a new folder with a value of a cell on the C directory

's Computer Specifications

This is what I've done
mkdir "C:\\ C3"

I want to take the value that I put in cell "C3", and by pressing a comand
button it create a folder on my hard drive like this

C:\"the value of cell C3"

's Computer Specifications

How can I create five more folders after that

"Mike H" wrote:

> Try this
>
> MkDir "C:\" & Range("C3").Value
>
>
> Mike
>
> "David" wrote:
>
> > This is what I've done
> > mkdir "C:\\ C3"
> >
> > I want to take the value that I put in cell "C3", and by pressing a comand
> > button it create a folder on my hard drive like this
> >
> > C:\"the value of cell C3"

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: creating a new folder with a value of a cell on the C directory	Mike H	Microsoft Excel Programming	0	11th Nov 2008 09:54 PM
Creating Directory Structure from Cell Value	elky.man@gmail.com	Microsoft Excel Worksheet Functions	5	7th Dec 2007 09:33 PM
Cache invalidate when creating a folder in app root directory	Khafancoder	Microsoft ASP .NET	4	4th Jul 2007 12:04 AM
Creating a new folder in a windows directory with VBA	=?Utf-8?B?TUphdEFmbGFj?=	Microsoft Access VBA Modules	2	12th Jul 2006 08:26 PM
desktop.ini & folder.htt files creating themselves in every directory I go into	AdeK	Windows XP Internet Explorer	0	10th Sep 2003 01:19 PM