How to quit an excel object?

[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

 

[Cor]

Hi Norton,

I only have some links about this for you.

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/...1e-3060-4f71-a6b4-01feba508e52&displaylang=en


I hope this helps a little bit?

Cor

 

[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