hi
end the workbook before close event....

Private Sub Workbook_BeforeClose(Cancel As Boolean)

ActiveWorkbook.SaveAs Filename:="YourfullFilePathAndName", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

End Sub

regards

FSt1

"Gita" wrote:

How can we back up an excel file in our hard disk without using SAVE AS
command in our hard disk each time we close the file.
I want to have a update copy of the excel file on my hard disk without
others know that this file is being backuped up some where in the hard disk
while closing it.

THANK YOU