About Excel.Application

[gaojing]

I created a excel.application and also a workbook and worksheet. I get the data from the database and write those data to the excel sheet I created.

After write, I want to close the application. So I use "Set xlapp=Nothing" to delete the applicaation. But I met a problem: when the data in the excel file is little, I can close the application successfully; while when the data in the excel file is much more, I cann't delete the application, after I run "Set xlapp=Nothing", and then I press "Ctrl+Alt+Del", I still can see the excel process in the process list.

Who can tell me how can I delete the excel application completely?

Thank you very much!

[Cakkie]

Tell excel to quit rather than setting the object to nothing. also, you can set the visibility property to true, so you can see what's happening. before quiting, be sure that he sheets and workbook are closed.

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook