Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you make a backup file - .bak or MS equivalent?
I have been using Lotus. When you SAVE AS you are given the choice to make a
BAK (backup) file. Is there a similiar command in Excel? When I use SAVE AS it just asks if I want to replace. Thanks for any help. |
#2
|
|||
|
|||
Another approach saves the file in a backup folder.
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 "Terry_BWL" wrote in message ... I have been using Lotus. When you SAVE AS you are given the choice to make a BAK (backup) file. Is there a similiar command in Excel? When I use SAVE AS it just asks if I want to replace. Thanks for any help. |
#3
|
|||
|
|||
Hi Terry
File Save as Tools General options, checkmark in 'Always create backup'. George Gee *Terry_BWL* has posted this message: I have been using Lotus. When you SAVE AS you are given the choice to make a BAK (backup) file. Is there a similiar command in Excel? When I use SAVE AS it just asks if I want to replace. Thanks for any help. |
#4
|
|||
|
|||
Thanks to both of you for the help.
"Don Guillett" wrote: Another approach saves the file in a backup folder. 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 "Terry_BWL" wrote in message ... I have been using Lotus. When you SAVE AS you are given the choice to make a BAK (backup) file. Is there a similiar command in Excel? When I use SAVE AS it just asks if I want to replace. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a way to make an Excel file smaller than 296K? | Excel Discussion (Misc queries) | |||
How do I make a backup file of my excel document? | Excel Discussion (Misc queries) | |||
Excel opens my file and a book1.xls, make it stop? | Excel Discussion (Misc queries) | |||
How do I shut off making a backup copy of a file when I save in E. | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |