View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Closing Excel Completely

David,

Application.Quit
should do the trick.

If using the Activeworkbook.Save, you can use this
in place of the ActiveWorkbook.Close

John

David W wrote:

How do I get excel to close all the way out
I got this code to almost to do it but it don't

Private Sub CommandButton1_Click()
MsgBox "Please Call In"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub