View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MurrayB MurrayB is offline
external usenet poster
 
Posts: 10
Default Code to close many open workbooks

Please can somebody help with the code to close all open workbooks without
referring to them by name. I often have to open about 30 workbooks and
closing them down is a waste of time.

Also, I use Excel 2007 but the workbooks are mostly in Excel 2003. I need
all the workbooks saved but without the Check Compatibility checked. Please
help