Closing down all open files within Excel

[Matt]

Is there a line of code that will close all files open at the present time in excel rather than writing code to close each seperate workbook?

thanks

Matt

 

[codger]

In Excel, holding down the shift key when selecting 'File' from the menu produces a 'Close All' option.

In code, you can do,

Workbooks.Close

 

[Al Chara]

To add onto codger's code, try application.displayalerts=false before workbooks.close. This will turn off the save box.

 

[Matt]

Thanks Codger, I was trying to specify workbooks("*.*").close and hence failed dismally. Interesting holding the shift key down and then going to the file menu - haven't seen that before! Any other interesting variations that add buttons to the standard menus?

 

[codger]

Open experimentation has yielded only shift+edit for copy and paste picture. That's useful for capturing screenshots and passing them around in spreadsheets (like from IT challenged users in an email).

One use for the close all is the ability to save hidden workbooks; elsewise you (more or less) have to exit before you're given the chance to save them.