Macro to close all open workbooks save two not working

Hi,

I need a macro to close all open workbooks except two of them, named say ab_cd_de.xlsm and fg_hi_jk.xlsx. (using these weird formats because the actual file names are similar (long names with many underscores).

The macro is located in the ab_cd_de file.

I am using the following macro:

Please Login or Register  to view this content.

I have also tried using the following code:

Please Login or Register  to view this content.

Both of the codes above fail to retain the two excluded files above and close one of them as well.
In effect I am left with only the fg_hi file for the first stretch of code and the ab_cs file for the second stretch.

Is there any way that I can ensure both of the files remain open after the operation?

You could try leaving the TRUE condition blank and performing your function on FALSE -

Please Login or Register  to view this content.

Dave H9