View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
 
Posts: 290
Default Macro Code for closing excel...

For Each w In Application.Workbooks
w.Save
Next w
Application.Quit

I think that does it, havent tested it yet though!,, might be better to
do the save first and then time delay the quit as it will be real slow
on a big workbook

HTH

Duncan