Thanx Skip&VbMax - 1 more ?- I need To Search C for the folder 1

[addicted2]

Thankyou heaps for your help people "RE:I need to create a folder in c:" was great and fast.
I have another situation that I need help with once a name has been entered into the input box and before it creates a new folder is there a code that will search C:Household to make sure the folder name doesn't already exist and if it does display a message box "Name Exists. Try again"

Cheers

Tony s-)

 

[ide]

use something like this:

If Dir("c:\Household", vbDirectory) = "" Then
Call MkDir("c:\Household&quot
Else
MsgBox "Name Exists. Try again"
End If

or...in your case:

x = InputBox("Enter new folder name:&quot
If Dir("c:\" & x, vbDirectory) = "" Then
Call MkDir("c:\" & x)
Else
MsgBox "Name Exists. Try again"
End If