Lyn has attended:
Excel VBA Intro Intermediate course
Automatic backup
How do I set a workbook to creat an automatic back-up copy when I save?
RE: automatic backup
Hi Lyn
Just checking if you are asking for a way using VBA to create a backup copy. There is no automatic way under Excel Options. You can turn on the Autorecovery feature which saves a workbook if there is a power outage or in version 2010 if a file is not saved.
Doug
Best STL
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.