The problem may be, though it should not be, that when an exception occurs (because of wrong password, may be), the workbook that is created within the for..next loop is still open (it gets closed only when no exceptions are genrated). Within the catch.. end try segment, close the workbook.

Technically, as workbook is connected to the application, it should close when the application closes.

Let me know if this helps.