Hi,
I have several workbooks that use a routine to copy a worksheet an
then open the Save As dialog box.
What I would love to be able to do is to have a routine that looks a
the folder the original workbook is already saved in, create
subfolder in that folder, with a particular name and save the copy o
the worksheet in that new subfolder. Hope I'm clear

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=51888