Hi,

We have a Visual Basic 6.0 application. In that, we have about 20 excel reports. When we access 15 of those excel reports from within the VB application, it works alright. When we try to access the other 5 reports, the excel report opens alright in a separate window but the VB application closes down behind it.

We had Windows 2000 O/S until recently and we have upgraded to Windows 2003 O/S recently. Not sure if this issue is due to the change in O/S. The database used in SQL Server 2000 (same version before and after the O/S has been upgraded from 2000 to 2003). We are using Excel 97 version.

Any help in this regard is greatly appreciated.

Thanks
ourspt