Hello - many thanks for your help but its not working. I think you are concentrating on if there is no BEMSID then close the workbook but BEMSID will always be in the file which is why the file is remaining open. The scripting dictionary is specifically looking at x(i,4) for:

Overtime
Overtime On Saturday
Overtime on Sunday
Saturday Premium
Sunday Premium
Travel
Travel Saturday
Travel Sunday/Holiday

Its when none of the above are within the file that I need the macro to close the weeklyFN workbook - does that make sense?

Kind regards
Leanne