Thanks for all your responses.

I will use the solution Steve posted as this works.

Steve - there will always only be one .bak file in this folder at one time but thanks for making me aware.

Thanks again all.