What other code have you got in your routine?

for instance,
Set oWS = oExcel.ActiveSheet

Range("A1").Value = 25
Application.DisplayAlerts = False
Workbooks("Book1").Close

should be

Set oWS = oExcel.ActiveSheet

oWS.Range("A1").Value = 25
oExcel.DisplayAlerts = False
oExcel.Workbooks("Book1").Close

If you do not Explicitly refence the Excel object you will get
Excel will remain referenced even though you close & quit.




Hcoms wrote:

Hello,

I know this question has been asked a number of times and i have looked
through google for an answer. However i still have not found an answer to
how to completely unload Excel from vb6 without ctl+alt+delete.
i use the standard code to open an excel doc using late binding
Dim xlapp As Object

Set xlapp = CreateObject("Excel.Application")
xlapp.Visible = True

Dim iNew As Integer
Dim iOld As Integer

Dim wb As Workbook
Dim ws As Worksheet

And to close i use this:
xlapp.ActiveWorkbook.Close False

xlapp.Quit
xlapp.UserControl = False

Set ws = Nothing
Set wb = Nothing
Set xlapp = Nothing

Excel still is in the task manager and if you attempt to run the code again
before closing the vb project it will crash each time!! Please Help!!!