Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making a backup
How can I make a copy of a workbook in another drive,
every time it is saved. I'd only want one copy which is subsequently overwritten each time the original is saved Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making a backup
This will create a sub directory in any directory and save a copy there as
well as save. Sub Backup() 'kept in personal.xls & assigned to toolbar button On Error GoTo BackupFile MkDir CurDir & "\Backup" BackupFile: With ActiveWorkbook MyWB = .Path & "\BACKUP\" & .Name .SaveCopyAs MyWB .Save End With End Sub -- Don Guillett SalesAid Software "Dennis" wrote in message ... How can I make a copy of a workbook in another drive, every time it is saved. I'd only want one copy which is subsequently overwritten each time the original is saved Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Backup | Excel Discussion (Misc queries) | |||
backup?? | Excel Discussion (Misc queries) | |||
backup | New Users to Excel | |||
How do I shut off making a backup copy of a file when I save in E. | Excel Discussion (Misc queries) | |||
backup | Excel Programming |