Creating backup of a data file

's Computer Specifications

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

's Computer Specifications

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
>

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating batch file for backup	=?Utf-8?B?QW50aG9ueQ==?=	Windows XP General	3	25th Oct 2006 12:51 AM
HELP! Unrecognized data in system backup file (backup.bkf)	=?Utf-8?B?QmlnU3R1?=	Windows XP General	0	7th Dec 2004 11:29 PM
How to make instant backup of file (Clustering and Redundant Backup) of Data(Account System) in XP	hon123456	Windows XP General	3	28th Sep 2004 02:13 AM
creating backup file from a form	Bill	Microsoft Access Forms	1	10th Oct 2003 02:24 PM
creating a backup of mdb at the end of day to separate file	Mar	Microsoft Access Getting Started	0	18th Sep 2003 01:33 PM