Excel close methods? - Xtreme Visual Basic Talk

03-02-2005, 10:44 AM

bmn

Freshman

Join Date: Aug 2004

Posts: 36

Excel close methods?

Edit by Moderator:
Please use the [vb][/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:

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.

Code:

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!

Last edited by Timbo; 03-02-2005 at 10:50 AM. Reason: Added vb tags, edit this post to see how to do it yourself

03-02-2005, 10:49 AM

Timbo

Green-Eyed

Super Moderator
* Guru *

Join Date: May 2001

Location: Bangkok, Thailand

Posts: 10,261

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.

__________________
"He's not the Messiah. He's a very naughty boy!" - Brian's mum

Can't find the answer? >> Try something new!
Become a Professional