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.
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.
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.
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
[email protected]
"Terry_BWL" <[email protected]> wrote in message
news:[email protected]...
> 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.
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
> [email protected]
> "Terry_BWL" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>
glad it helps
--
Don Guillett
SalesAid Software
[email protected]
"Terry_BWL" <[email protected]> wrote in message
news:[email protected]...
> 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
> > [email protected]
> > "Terry_BWL" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks