Backup Shared Workbooks

P

Paul.

Hi,
I have a Shared Workbook (Daily Report) containing 10 Worksheets + 1 Summary
Sheet, and want it to be backed up at midnight every day.
I Also want a Copy of the Summary Sheet to be created in another workbook
every day so as to obtain at the end of the month a separate workbook 30
worksheets (1 Copy of the Summary sheet per day.

If someone could explain me the way to do this it would be excellent !

Thanks in advance,

Paul.
 
Top