Automatically creating a back copy in other location which is updated at all times

Hi ,
I am using this code to make an automatic copy of work book in other destinations.
I am learning on how to write the code.
My file name is ABCDE and it is at C:/TP/NN ( NN is the folder)
Path where back up copy is to be saved is C:/TP/BK( BK is the name of the folder)
I want the data on back copy saved every time the main copy is modified, however if some one tries to delete any information, then the back up copy remains as it is.
How it can be possible???
I have a general code, but dont know how to rewrite it.
Please help...

Sub MyBackup()
' Saves a renamed copy of this workbook in the nominated folder as a backup.
' Pre-requisite: PathExists Function (see below)

Dim fname As String
Dim Path As String
Dim PathnName As String
Dim Mydate as String

On Error Resume Next
MyDate = Format(Date, "yymmdd") & " "
Path = "[Specify path for backup here, including final \]" 

fname = MyDate & ThisWorkbook.Name
PathnName = Path & fname

If PathExists(Path) Then
    ThisWorkbook.SaveCopyAs PathnName
Else
    Exit sub
End If
End Sub

Public Function PathExists(pname) As Boolean
' Returns TRUE if the path exists
' Code source: http://www.j-walk.com/ss/excel/tips/tip54.htm
Dim x As String

On Error Resume Next
x = GetAttr(pname) And 0
If Err = 0 Then PathExists = True Else PathExists = False

End Function

In the ThisWorkbook module, create a macro that makes a backup copy of the file everytime the file is opened. I can't imagine any better backup method since you will have difficulty knowing any other time whether the macro was edited.

Private Sub Workbook_Open()
Dim SavePATH As String, fNAME As String

SavePATH = "C:/TP/BK/"                                      'remember the final /
fNAME = Format(Now, "#.00000") & " " & ThisWorkbook.Name    'creates a filename like this:    '43456.12345 Filename.xls'
ThisWorkbook.SaveCopyAs SavePATH & fNAME

End Sub

No, the SaveCopyAs method is the one to use when needing a backup copy of a file before any changes have occurred.

Follow the instructions in post #2 as to where the macro must reside.

Which code module did you put it in? I tested the macro as given moments ago and it's working fine. I'm guessing you still don't have it in the correct module. Read post #2 again.

Glad to help. Hope you're feeling better.