Are you opening that file? If so , use

Activeworkbook.SaveCopyAs Filename:="C:\mybackups\myfile.xls"

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:6b60cd9c4e0d4@uwe...
Hi . I have been asked to creat a back up file of a data base in case the
computer crashes onto a cd and update the back up on a weekly basis. the
file
in based in the C:\Program Files\. I am unsure to how to do this. Can
anyone help. Thanks

--
Message posted via http://www.officekb.com