Creating backup of a data file
 

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

Creating backup of a data file
 

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

Creating backup of a data file
 

Sorry to being a bit daft, but where do find Activeworkbook?

Bob Phillips wrote:
Are you opening that file? If so , use

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

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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200612/1

Creating backup of a data file
 

Activeworkbook is a VBA built-in pointing to the active workbook.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:6b630cd16a289@uwe...
Sorry to being a bit daft, but where do find Activeworkbook?

Bob Phillips wrote:
Are you opening that file? If so , use

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

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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200612/1