Select Case Statement

Originally Posted by Juw

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

Hi,

I think that

Please Login or Register  to view this content.

is what you are looking for

hth
---