Application quit

Topic

New Reply

Hi all,

When using application.quit, I cannot seem to get Excell2000 to actually quit. I am using the Analysis ToolPak. When I go into the VBE, the only thing there is “funcres.xla”. Is there something else I should be looking at to fully close Excel?

This is my code (with Interface as a userform):

Private Sub CommandButton5_Click()
Interface.Hide
Unload Interface
Application.ScreenUpdating = False
Application.Visible = True
Application.DisplayAlerts = False
ThisWorkbook.Close
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Application.Quit
End Sub

Thanks,

Reply | Quote

Replies

Michael,

I don’t think Application.Quit works from a control. I would suggest that as you are closing a workbook at the same time that you transfer the Application.Quit statement (and maybe some of the rest of the code) to either the Workbook_BeforeClose or Workbook_Deactivate events and see if that helps.

Andrew C

Reply | Quote

That worked beautifully!

Thanks

Reply | Quote