Hcoms,
You say you are using late binding. Then you can't have the references to
"Workbook" & "Worksheet" as you need a reference the Excel library.
For me the above code allows Excel to unload, so the problem is in some of
the code that you have not shown here.
Also .UserControl is read only.
NickHK
"Hcoms" wrote in message
...
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!!!