I save my files normally. Then I'll use windows explorer to copy them to my
backup folders (LAN drives, CD/DVD's, or whatever).

But if you wanted, you could have a workbook event that saves a copy to a
specified folder each time you save the workbook.

Option Explicit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

On Error Resume Next
MkDir "C:\mybackups"
Me.SaveCopyAs Filename:="c:\mybackups\mynamehere.xls"
On Error GoTo 0

End Sub


This code goes under the ThisWorkbook module.

And it overwrites the previous backup (if it exists) each time you save your
file.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

wrote:

How do I create a backup file to be stored at different directory? How to
specify the directory that I want the backup file to be stored?

Thanks,
Tom

--

Dave Peterson