Excel close methods?
Edit by Moderator:
Please use the [vb][/vb] vb tags with your code
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
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.
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
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