|
-
Apr 18th, 2000, 10:04 AM
#1
Thread Starter
Hyperactive Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|