View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_2_] NickHK[_2_] is offline
external usenet poster
 
Posts: 29
Default Completely unloading excel from vb6. Is there an answer?

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