Yes, Excel can.

Look in the Help for the Ontime method.


"Robert B." schreef in bericht
...
Can Excel at a specified time (say 23:59) copy a worksheet and save it?
Say
you have three worksheets open (A,B,C) and you want Worksheet C to be
copied
automatically.