Is this a Win98 bug?

[joey o.]

I've been having trouble closing excel through vb.
In a prior post I was able to fix my code. It now closes correctly on NT but on my home machine(Win98), it remains visible in the task manager - thus in the memory - even though it appears to close on the taskbar. It becomes a zombie not letting me reopen it or completly close it. It only completly leaves the task manager when the app closes. There doesn't seem to be any magic with the code but here's how I open it and close it. Any Help? Or is this a real bug?

'Heres how I open it:
Set appxl = CreateObject("Excel.Application")
Set xl = appxl.Application
xl.Workbooks.Open FrmCheck.cboPath.Text
xl.Sheets(al).Select
xl.Visible = True

Here's how I close it: (I've tryed this in every order)
appxl.ActiveWorkbook.Close savechanges:=False
Set appxl = Nothing
Set xl = Nothing

Has this happened to anyone else? Is there a workaround?
Thanks Again,
Joey O

Joey,

Have never tried to close an excel iteration from within vb, but l know that win98 has a problem with some apps leaving foot prints, (maybe a kernal thing).

The only problem l get is the odd PC showing the blue screen of death...that PC then needs to be rebuilt.

Try, migrate your app to the Win98 machine and run from the IDE to see if you get the same problem.

[JeffSM]

Hi, I had a similar problem using my own ActiveExe and only adding DoEvents I solved this problem. I suggest you try this!

Jefferson

appxl.ActiveWorkbook.Close savechanges:=False
DoEvents
Set appxl = Nothing
Set xl = Nothing