If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Workbook back up
Hi,
Is there a way to have excel create a backup file saved somewhere each time the workbook is either opened or closed? I know there is the auto recover but it doesn't really save a back up file that I could open when ever I need to. Thanks, |
#2
|
|||
|
|||
Workbook back up
This is one I use.
Sub Backup() 'kept in personal.xls & assigned to toolbar button On Error GoTo BackupFile MkDir CurDir & "\Backup" BackupFile: With ActiveWorkbook MyWB = .Path & "\BACKUP\" & .Name .SaveCopyAs MyWB .Save End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Aris" wrote in message news Hi, Is there a way to have excel create a backup file saved somewhere each time the workbook is either opened or closed? I know there is the auto recover but it doesn't really save a back up file that I could open when ever I need to. Thanks, |
#3
|
|||
|
|||
Workbook back up
Thanks! This was great. it worked perfectly.
"Don Guillett" wrote: This is one I use. Sub Backup() 'kept in personal.xls & assigned to toolbar button On Error GoTo BackupFile MkDir CurDir & "\Backup" BackupFile: With ActiveWorkbook MyWB = .Path & "\BACKUP\" & .Name .SaveCopyAs MyWB .Save End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Aris" wrote in message news Hi, Is there a way to have excel create a backup file saved somewhere each time the workbook is either opened or closed? I know there is the auto recover but it doesn't really save a back up file that I could open when ever I need to. Thanks, . |
Thread Tools | |
Display Modes | |
|
|