How to quit an excel object?

  • Thread starter Thread starter Norton
  • Start date Start date
N

Norton

I type the following code to open/close an excel appz

Dim oExcel As Excel.Application
oExcel = new Excel.Application
....
....
...
If Not oExcel Is Nothing Then oExcel.Quit()
If Not oExcel Is Nothing Then oExcel = Nothing


It returns no error message and the application was shut down, however i
still can see it on taskbar and consume many memory

also is there any method to detect if the excel application is opened or
not.
I want to open the workbook directly is the excel application has been
opened.

Any advise?

Regards,
Norton
 
Thx Cor.

I traced the problem and i observed that i need to release all Excel relatd
object become run the Excel Object. Like sheet object and workbook object

Again, thx for your help
 
Back
Top