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.
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.