All,

I have a problem with using the application.quit command - as I understand it, the application.quit should immediately jump to the Auto_Close (if exists) and then close any workbooks and quit Excel - however, when I run it, my code continues to run through the end of the sub (see simplified code attached):

Sub test()
Application.Quit
MsgBox ("Test Message 1!")
MsgBox ("Test Message 2!")
MsgBox ("Test Message 3!")
MsgBox ("Test Message 4!")
MsgBox ("Test Message 5!")
MsgBox ("Test Message 6!")
MsgBox ("Test Message 7!")

End Sub

When I run this - I get 7 message boxes, then after the 7th, Excel closes. Any thoughts

Thank you,

Andrew

Hi

I have had problems with Application.Quit in Office 97, I found that I had to close my sheets with code before I could quit excel. Try directing the flow of your code, simalar to error trapping, so that you do any tidying up then have Application.quit as your last statement.