Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
How to close Excel object, if asp page is closed unexpectedly?
We faced some problem with our Internet application. Several dial_up users tried to open Excel using our on-line application and had difficulties to keep application running and closed it. At the same Excel.exe remained running on backgorund on server machine. That caused biggest problem - application stop running completely. When we checked server we found out about 10 Excel.exe running sielently on background. There is code to open/close Excel when asp page run normally like Set objSqlExcel = Nothing but it does not work if asp page closed/user tried to refresh page/switch to another page.
Question is, is there way to kill Excel object, if asp page is closed/refreshed. Something like we do on VB VB.NET on Form Unload event. [b]This not .NET application![/b]