Here is one I use to backup to the same folder in a sub folder. Modify to
suit.
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
SalesAid Software
"Mark" wrote in message
...
when i save my budget report workbook, can i also save my
backup copy held in a diffrrent drive.
thanks
mark