Saving backup workbooks

  • Thread starter Thread starter Matt Edwards
  • Start date Start date
M

Matt Edwards

How do you set excel 2000 to automatically save a backup
workbook file when you save a workbook?
 
Here is one I use to save to the same name in any directory\backup

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to save same excel workbook in different folders as a back up 2
Merge Multiple workbook sheets into one workbook 0
Auto-save backup? 2
automatic backup? 2007 version 3
Excel 2007- can't get it to automatically make backups 1
auto save a backup copy of a workbook 1
Sharing workbooks limitations - Merged Cells 12
How to create absolue path link to another workbook (Excel 2003) 1

Back
Top