creating a file folder

[cmz21]

Hello,
I have found that I can create a directory using the code:

MkDir "C:\My Documents"


I was wondering if there is a simple way to check if this directory already exists before it is created.

Thanks
cmz

 

[Trevil]

Search for help on MkDir

Since you're using the MkDir....

strPath = Dir("C:\My Documents", vbDirectory)
If strPath <> "" then
' It Exists
End if


"Hmmm, it worked when I tested it....

 

[cmz21]

thank you.....
I was missing the vbDirectory part. Working perfectly now.

cmz