View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
KJTFS[_2_] KJTFS[_2_] is offline
external usenet poster
 
Posts: 1
Default Close Open Woorkbook and Quit Excel

You will want a function like this, to run on the ontime.

Sub QuitApp()

Application.setwarnings false
ThisWorkbook.Save ''Might need to change if you have multiple WBs
open
Application.quit

End Sub


Keith
www.kjtfs.com


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