Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Automatically Generate A Backup File (XP-Office2003)

    Good morning all,

    I like to have a means that automatically generates a backup of my just loaded file...

    That is, after I loaded my workbook I want to have it saved before I start working with it and messing things up...

    Yes, I do keep a backup of my files, but not always and then it happens.......just shot my data...

    Thank you very much and
    best regards,

    Wolfgang

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automatically Generate A Backup File (XP-Offic

    Hi Wolfgang

    Try


    1) Save the file
    2) Save As (F12 key), then on the Save As Dialog menus: Tools --> General Options, check
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    Hi Jerry,

    thank you for your quick answer...

    What I'm really after is that the whole procedure should really be automated, meaning, without any manual intervention by the user...

    Sometimes others need to work with the file and before they start doing anything with it I like to have it saved, no matter if the additional changes are saved or not...

    I only want the original be preserved so that even I can't mess it up...

    Best,
    Wolfgang

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    Once you "save as" as directed, it will no do it automatically without intervention for that file.

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    Hi Steve...

    you are totally correct...BUT the main thing is: have it saved WITHOUT any manual intervention for the benefit of myself and others....

    Because if I/others do forget to do the initial save then my original data is already edited....may sound somewhat weird, but it's the truth...

    Best,
    Wolfgang

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    I don't understand. Someone will have to do it for the file

    You could have all files created create a backup by creating a defaul template with this option set and all files you create will auto create a backup. But I thought you wanted to only do this for individual files you create.

    If you want it for all files for everyone, create the template and put it in on all the computers.

    Steve

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    Are you wanting to save a copy that will remain untouched even if someone opens, edits and then saves?

    e.g.:
    File1.xls is opened.
    A copy is created as File2.xls
    The original file remains as File1.xls so that subsequent editing and saving of File1.xls leaves File2.xls unchanged.
    ???

    I remember there being a macro listed here that did this, but can't find it immediately. It involved saving File1.xls as File2.xls, then saving File2.xls as File1.xls so that the original file name remained.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automatically Generate A Backup File (XP-Offic

    Weeelll

    You could put this in your startup as a template for your main excel. You could create a folder called backup on your C: drive and place this code in This Workbook.

    Private Sub Workbook_Open()
    Dim Msg, Style, Title, Response
    Msg = "Do you want to back up this file ?"
    Style = vbYesNo + vbCritical + vbDefaultButton2
    Title = "Auto back up"

    Response = MsgBox(Msg, Style, Title, Help, Ctxt)
    If Response = vbYes Then
    fname = ActiveWorkbook.Name
    bacname = Left(fname, Len(fname) - 4)
    ActiveWorkbook.SaveCopyAs "C:BACKUP " & bacname & Format(Now(), "yymmddhhnn") & ".xls"
    ActiveWorkbook.Save
    Else

    End If


    End Sub


    I have attached an example for you to look at
    Jerry

  9. #9
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    Good morning Jerry....

    That's exactly it...

    No wonder I could not see the forrest before the trees....they were already cut...

    Thank you very much and have a nice day...

    Best,
    Wolfgang

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    As an extra option, have you seen: Autosafe.zip
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Automatically Generate A Backup File (XP-Offic

    Good morning Jan Karel,

    I actually work with your tool for quite a while already...................

    But as I mentioned above, I needed to have a means to automatically save a workbook upon opening and BEFORE any changes being made...

    Kind of like: Open and save me immediately...

    Thank you for your answer and have a nice day...

    Wolfgang

Posting Permissions

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