View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark mark is offline
external usenet poster
 
Posts: 196
Default Closing Excel Object

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.