+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Terry_BWL
    Guest

    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. #2
    George Gee
    Guest

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

    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.




  3. #3
    Don Guillett
    Guest

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

    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
    donaldb@281.com
    "Terry_BWL" <Terry_BWL@discussions.microsoft.com> wrote in message
    news:054D92CC-9405-46F6-9ED4-41AC5B6BBA23@microsoft.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.




  4. #4
    Terry_BWL
    Guest

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

    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
    > donaldb@281.com
    > "Terry_BWL" <Terry_BWL@discussions.microsoft.com> wrote in message
    > news:054D92CC-9405-46F6-9ED4-41AC5B6BBA23@microsoft.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.

    >
    >
    >


  5. #5
    Don Guillett
    Guest

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

    glad it helps

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "Terry_BWL" <TerryBWL@discussions.microsoft.com> wrote in message
    news:7A41493A-F7FD-4E6F-8253-EB4093D91D6C@microsoft.com...
    > 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
    > > donaldb@281.com
    > > "Terry_BWL" <Terry_BWL@discussions.microsoft.com> wrote in message
    > > news:054D92CC-9405-46F6-9ED4-41AC5B6BBA23@microsoft.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 Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1