Automatically creating a back copy in other location which is updated at all times

Which code module did you put it in? I tested the macro as given moments ago and it's working fine. I'm guessing you still don't have it in the correct module. Read post #2 again.