Closing Excel Object

M

Mark

I am accessing a Excel object from VB 6.0. To open the
object I use the following;
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets.Item(1)

My problem when I use the following code;
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
to close the object, the process is still runnig in the
background in the process list. What do I do to remove it
from the process list and actually close the object. I am
using windows 2000 OS.
 
T

Tom Ogilvy

you have probably created a non-releasable reference to excel in your code
(which you don't show). You must use fully qualified references to all
objects so they can be released

Rather than use

ActiveSheet.Name = "ABC"

you would use xlApp.ActiveSheet.Name = "ABC"

as an example.

This assumes that at the end of your code you

set xlSheet = Nothing
xlbook.Close SaveChanges:=False
set xlBook = Nothing
xlApp.Quit
set xlApp = Nothing
 
Top