I have the following case statement which take the
active workbook name as a input

Select Case ActiveWorkbook.Name
case is="workbook1.xls"
do something-------------

case is="workbook2.xls"
do something
end select

if want to know that if some other workbook is opened not mentioned in the above case statement how wil i generate the error message like unkown xls file