Detecting workbooks can be done with the dir statement.

If one is missing from your summary, you can use Sheets.Add and then
ActiveSheet.Name

For deleting, you may need to use application.displayalerts = false to
avoid confirmation dialog boxes appearing.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544287