VB exe gives error but no error in debug mode

Hi,

I have a situation where I use Excel reports in Visual Basic on a SQL Server database. I have about 20 reports. When I run the exe of the application and I go into five of the excel reports the VB applcation is closing down automatically, although the excel report opens alright.

When I go into the same reports through the code in Debug mode, the application does not close down and everything is alright.

Can anyone help me understand what are the reasons that could possibly cause this.

Thanks in advance
ourspt