View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger[_20_] Roger[_20_] is offline
external usenet poster
 
Posts: 15
Default Saving and Closing multiple files and Excel program

I am looking for 2 macros that I had in Excel 5 which don't work in Excel
2002. The first is a macro that Saves and Closes all open files except any
file which is BOOK1, or BOOK2 etc. The second is a macro that Closes all
open files and doesn't save them except any file which is BOOK1, or BOOK2
etc. In both cases the workbook is left open and the BOOK files are not
saved.

Any help would be greatly appreciated,

Roger