How do you make a backup file - .bak or MS equivalent?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry_BWL - 03 Jan 2005 19:15 GMT

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 to this Message

George Gee - 03 Jan 2005 19:30 GMT

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.

Reply to this Message

Don Guillett - 03 Jan 2005 19:31 GMT

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

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> 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 to this Message

Terry_BWL - 03 Jan 2005 20:01 GMT

Thanks to both of you for the help.

> Another approach saves the file in a backup folder.
>
[quoted text clipped - 14 lines]
> AS
> > it just asks if I want to replace. Thanks for any help.

Reply to this Message

Don Guillett - 03 Jan 2005 23:12 GMT

glad it helps

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Thanks to both of you for the help.
>
[quoted text clipped - 16 lines]
> > AS
> > > it just asks if I want to replace. Thanks for any help.

Reply to this Message