Method to back up a file on a specified time

[stevenjporteous]

I was wondering if there was a way to back up a file to a specified directory on a daily basis. My IT department has tried restoring files but on countless times cannot retrieve the file. Does anyone know a macro to save a file once a day for a week after a file has been created?

This would save me much pain.

 

[Mexcel]

As much as I like Excel I recommend you use a backup program yourself. Most backup programs can do regular backups. If you insist on using Excel you may want to try the Ontime() procedure to copy a file.