| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook creating Backup when saved? | Excel Discussion (Misc queries) | |||
| Creating Automatic Backup Files on another drive | New Users to Excel | |||
| Creating a Backup copy of workbook | Excel Programming | |||
| Creating a read only backup?? | Excel Programming | |||
| Creating excel backup files | Excel Programming | |||
Linear Mode
