Saving backup workbook problem with Excel 2002 SP2

M

Matt Edwards

I have selected 'Always save backup' in the save as -
tools - general options in my workbook, but I have to save
the workbook two or three times before it will save a
backup. Why is this?
 
D

Don Guillett

Dunno but you might like this

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
 
Top