Excel close methods?

Please use the vb vb tags with your code


hi,

I'm wondering what methods i need in order to completely close down an excel process.

I've successfully opened excel, created a chart and saved it however I am unsure which methods to call to

close it.

Here's the initialisation code:

Dim xlApp As Excel.Application
Set xlApp = New Excel.Application
Dim xlWkb As Excel.Workbook
Set xlWkb = xlApp.Workbooks.Add
Dim xlSht As Excel.Worksheet
Set xlSht = xlWkb.Worksheets(1)
Dim xlChart As Excel.Chart

and here's the process close methods im using at the moment.

Call xlWkb.Close
Call xlApp.Quit
Set xlApp = Nothing

so, basically, what I'm wondering is should I be calling any other methods too.

After exiting my VB app I stills ee one EXCEL.EXE process in my task manager so I know I'm not closing it

down fully,

Any help much appreciated!

There is a recent discussion on this topic here:
http://www.xtremevbtalk.com/showthread.php?t=212883

Read and implement all the suggestions made there first. But if that does not solve the problem, and you share the same version as the author, you may have to implement his workaround too.