+ Reply to Thread
Results 1 to 5 of 5

Backup file

  1. #1
    tkanasoot@yahoo.com
    Guest

    Backup file

    How do I create a backup file to be stored at different directory? How to
    specify the directory that I want the backup file to be stored?

    Thanks,
    Tom

  2. #2
    Michael
    Guest

    RE: Backup file

    Try Tools - Options - Save. This will automatically save a copy of your file
    every x minutes to the directory of your choice. HTH
    --
    Sincerely, Michael Colvin


    "tkanasoot@yahoo.com" wrote:

    > How do I create a backup file to be stored at different directory? How to
    > specify the directory that I want the backup file to be stored?
    >
    > Thanks,
    > Tom


  3. #3
    tkanasoot@yahoo.com
    Guest

    RE: Backup file

    Do I need to set up my file to always create backup?
    Does this saving feature save only the copy of my backup and not the
    original file?

    Thanks,

    Tom

    "Michael" wrote:

    > Try Tools - Options - Save. This will automatically save a copy of your file
    > every x minutes to the directory of your choice. HTH
    > --
    > Sincerely, Michael Colvin
    >
    >
    > "tkanasoot@yahoo.com" wrote:
    >
    > > How do I create a backup file to be stored at different directory? How to
    > > specify the directory that I want the backup file to be stored?
    > >
    > > Thanks,
    > > Tom


  4. #4
    Michael
    Guest

    RE: Backup file

    It will always create an autorecovery file - not quite the same as a backup.
    If you don't want to create your own backup when closing the file then maybe
    one of the MVP's who visit this site can suggest other settings or provide
    you with VBA code that will automatically save a second copy of your file to
    a different directory. Afraid that part is over my head.
    --
    Sincerely, Michael Colvin


    "tkanasoot@yahoo.com" wrote:

    > Do I need to set up my file to always create backup?
    > Does this saving feature save only the copy of my backup and not the
    > original file?
    >
    > Thanks,
    >
    > Tom
    >
    > "Michael" wrote:
    >
    > > Try Tools - Options - Save. This will automatically save a copy of your file
    > > every x minutes to the directory of your choice. HTH
    > > --
    > > Sincerely, Michael Colvin
    > >
    > >
    > > "tkanasoot@yahoo.com" wrote:
    > >
    > > > How do I create a backup file to be stored at different directory? How to
    > > > specify the directory that I want the backup file to be stored?
    > > >
    > > > Thanks,
    > > > Tom


  5. #5
    Dave Peterson
    Guest

    Re: Backup file

    I save my files normally. Then I'll use windows explorer to copy them to my
    backup folders (LAN drives, CD/DVD's, or whatever).

    But if you wanted, you could have a workbook event that saves a copy to a
    specified folder each time you save the workbook.

    Option Explicit
    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

    On Error Resume Next
    MkDir "C:\mybackups"
    Me.SaveCopyAs Filename:="c:\mybackups\mynamehere.xls"
    On Error GoTo 0

    End Sub


    This code goes under the ThisWorkbook module.

    And it overwrites the previous backup (if it exists) each time you save your
    file.

    If you're new to macros, you may want to read David McRitchie's intro at:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    tkanasoot@yahoo.com wrote:
    >
    > How do I create a backup file to be stored at different directory? How to
    > specify the directory that I want the backup file to be stored?
    >
    > Thanks,
    > Tom


    --

    Dave Peterson

+ 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