Save All files without closing

[pagrender]

Hello,

As I am hearing thunder outside, I let everyone in my office know that they should "save often".

That got me to thinking... is there a command to save all open Excel files at once?

In Word, you can add the "Save All" button to the Quick Access Toolbar but there is not one for Excel 2007.

I know if you exit Excel it will ask to save all the files, but that's not what I am looking for. I would like to be able to keep all of my files open. Will it have to be done in VB?

Thanks,
Pete

 

[matttclark]

this may still work, don't know of anything else

http://support.microsoft.com/kb/131333

Visual Basic Macro to Save All Open Workbooks in MS Excel