L
lobster
I have very kindly been given a sub to create backups. Is it possible t
amend this so that the file name it creates for the backup includes th
date ? Basically I dont want to overwrite the backup file everytime an
I would like to be able to search through the backups periodically.
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
Would be really grateful if someone could have a look at this. It woul
be ideal if the file was named say...
04122003.xls
Many thanks
amend this so that the file name it creates for the backup includes th
date ? Basically I dont want to overwrite the backup file everytime an
I would like to be able to search through the backups periodically.
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
Would be really grateful if someone could have a look at this. It woul
be ideal if the file was named say...
04122003.xls
Many thanks