Use
mkdir "C:\LOA\" & strProjectNumber
before you save the file.
Co
--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile:
http://www.excelforum.com/member.php...fo&userid=3435
View this thread:
http://www.excelforum.com/showthread.php?threadid=54552