Something like
if dir("C:\LOA\" & strProjectNumber,vbdirectory)<"" then
msgbox "Folder already exists!", vbcritical
exit sub
' or whatever...
endif
--
colofnature
------------------------------------------------------------------------
colofnature's Profile:
http://www.excelforum.com/member.php...o&userid=34356
View this thread:
http://www.excelforum.com/showthread...hreadid=545527