If I understand, you are left with an invisible instance
of Excel. Not an answer to your question, but to get out
of trouble Robert Bruce has a vbs script he has titled:

"Activate A Lost, Hidden Excel Instance"

http://myweb.tiscali.co.uk/xlvba/exc...elop/index.htm

Regards,
Sandy
savituk yahoo co uk

-----Original Message-----
I've got the following problem:

When I open an excel file from VB6, save it and close it
again EXCEL
does not remain in the taskbar, but when I make a copy of
a sheet and
save and close the file excel does remain?

Anybody has an idea?

This doesn't work:

Dim XLObj as Public XLObj As Excel.Application
Set XLObj = CreateObject("Excel.Application")
XLObj.Workbooks.Open
"c:\test_file.xls"
XLObj.DisplayAlerts = False
XLObj.ActiveWorkbook.Sheets("testsheet").Copy
Befo=Sheets(1)
XLObj.ActiveWorkbook.Save
XLObj.ActiveWorkbook.Close
XLObj.UserControl = False
XLObj.DisplayAlerts = True
XLObj.Quit
Set XLObj = Nothing

This works:
Dim XLObj as Public XLObj As Excel.Application
Set XLObj = CreateObject("Excel.Application")
XLObj.Workbooks.Open
"c:\test_file.xls"
XLObj.DisplayAlerts = False
XLObj.ActiveWorkbook.Save
XLObj.ActiveWorkbook.Close
XLObj.UserControl = False
XLObj.DisplayAlerts = True
XLObj.Quit
Set XLObj = Nothing
.