The old application.quit problem
 

The problem is that you can't close the workbook and continue the code.
Think about it.

--
Don Guillett
SalesAid Software

"phreud " wrote in message
...
Hello,

I'm totally lost. I've been searching through these forums and the
internet for an answer, but I can't solve this problem. I have a splash
screen (userform) from which users can open different forms in my
application. The splash screen also has a quit button which is supposed
to close Excel down, but it still apperas in the task manager.

From what I've read, I think I understand the problem, but I have no
idea how to solve it. I'm not creating new instances in my code? Not
sure if I should? Anyway, I'll give a brief explanation of what I'm
doing:

I have 1 workbook with 3 sheets. I have a userform acting as a splash
screen. The first thing I do when someone opens my xls file is (code
for ThisWorkbook):


Code:
--------------------
Private Sub Workbook_Open()
Application.Visible = False
frmSplash.Show
End Sub

--------------------


On my splash screen, I have a quit button with the following code:


Code:
--------------------
Private Sub btnQuit_Click()
For Each w In Application.Workbooks
w.Close False
Next w
Workbooks(1).Saved = True
ThisWorkbook.Close False
Application.Quit
--------------------


Clicking this still leaves the Excel process running. Can someone
please point me in the right direction?

Thankyou in advance.


---
Message posted from http://www.ExcelForum.com/

The old application.quit problem
 

Tom:

Thanks alot! That sure solved the problem. It even works after I ope
up new forms and start fiddeling around. :)


Don:

That makes sense, ofcourse. I think I was intimidated by all thes
horror stories about keeping track of created instances I've bee
reading about :)


Thankyou both

--
Message posted from http://www.ExcelForum.com