It can be caused by some special error interception expression, which works
just as you say - closing workbook if there is some error during workbook
loading.
I suggest to open application turning off macro and then check if there is
any special error section in Workbook_open() procedure.
Put comment character before lines of error section, then save and close
application. Open application again and try to see if debugger shows
incorrect part of code making problems.

Regards
Mario

Uzytkownik "divya sanam" napisal w wiadomosci
...


I've got an excel application which on opening shows an message box
compiletime error 1004:application or object defined error when I click
ok the whole application is closed not allowing me to view the vba code
.It also closes other workbooks which are open .kindly suggest a soln.

*** Sent via Developersdex http://www.developersdex.com ***