Is there a way to program a file in excel to use the SaveCopyAs
function at a certain time every day?

The filename will remain constant and the older file will be deleted
first (Kill).

Now an even harder question - can you program excel to do this and save
it as a different file everyday?

Either one of these solutions would save me much time and labor. Thank
you.