Here is my problem I have a save as command as follows:

ActiveWorkbook.SaveAs _
Filename:="L:\" & JobNoTXT.Value & "\xldata\" & ComboBox1.Value & ".xl
"

The "xldata" is the Sub folder and has a new name in new projects whic
is "Design Data" is there a way to save to the "xldata" and if that doe
not exist to save to the other name "Design Data"

Thanks for any help. :

--
HelpM
-----------------------------------------------------------------------
HelpMe's Profile: http://www.excelforum.com/member.php...nfo&userid=452
View this thread: http://www.excelforum.com/showthread.php?threadid=27224