View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Application.quit


You should always post YOUR macro for comments. Try this

Sub CLOSE_ALL()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each w In Application.Workbooks
If w.Name < ThisWorkbook.Name Then
w.Save
w.Close
End If
Next w
ThisWorkbook.Save
Application.Quit
End Sub


--
Don Guillett
SalesAid Software

"OlieH" wrote in message
...
Thanks for any help. I am running a macro that saves all workbooks and
then
does application.quit. Excel opens and closes the VisualBasic window.
Since
others will be using this macro, I wish to elimanate this opening/closing.
Thanks for the hlep.