On error resume next
mkdir "C:\ABC"
mkdir "C:\ABC\EFG"
On Error goto 0

--
Regards,
Tom Ogilvy

"funkymonkUK"
wrote in message
...

hi does anybody know how i am find out if the folder already exist I
have a macro which opens a specific folder and then creates a new
folder within. It works how ever everytime I run and if the folder
exists it comes up with an error Run-time error 75 : Path/file access
error. which is correct as it cannot create two folders exactly the
same.

any ideas around this?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=475775