Thanks for the idea , however it still keeps Excel loaded! Any more ideas??
"Bob Phillips" wrote in message
...
Try not closing the file.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"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!!!