View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ralph Ralph is offline
external usenet poster
 
Posts: 79
Default Macro to close Excel 2007

How do I close out of Excel completely? I've tried this:
Sub Macro1()
'
' Macro1 Macro
' Save and close workbook
'
ActiveWorkbook.Save
ActiveWorkbook.Close

this only closes the active workbook and I need to close Excel completely.

thanks