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...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en
I hope this helps a little bit?

Cor

[Cor]

Hi Norton,

I only have some links about this for you.

Office
http://support.microsoft.com/default...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...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
"Norton" <no********@hotmail.com> wrote in message
news:uG**************@TK2MSFTNGP09.phx.gbl...

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

[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
"Norton" <no********@hotmail.com> wrote in message
news:uG**************@TK2MSFTNGP09.phx.gbl...

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