View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George
 
Posts: n/a
Default How do i save all open files in excel at once?

I don't think there is.
It kind of goes against the design since you can save multiple sheets in
a single workbook. While word can only work with single documents.

Wouldn't be hard to write a little VBA routine and save it in your
personal workbook then use either a shortcut or toolbar to run it.

Sub SaveAll()
Dim w As Workbook
On Error Resume Next 'ignore any errors (for the moment)
For Each w In Workbooks
w.Save
Next
End Sub

I would probably add some better error checking, but for now any errors
caused by saving would just be ignored (eg. disk full)

George

ved_rocker wrote:
Word has an option whereby you can save all the files that are open. This
saves considerable time in saving huge amt of related files that are open. Do
we have any such option with Excel?