close all workbooks in other folder

[dsrt16]

I have several workbooks in a make your day folder categorized under several sub folders.

Each workbook has a macro that calls the following macro:

Please Login or Register  to view this content.

I want the macro to close all workbooks opened in the make your day folder, but right now it will only close the workbooks found in the same subfolder.

Example: Make your day/specials/music.xls will only close workbooks found in the specials folder, but I need it to close all open workbooks from the entire make your day folder.

[jrdnoland]

I suspect that the workbook that is closing all the other workbooks is getting closed before the code has a chance to close all open workbooks. Try something like this:

Please Login or Register  to view this content.

[dsrt16]

Wow that worked beautifully! Thanks!