+ Reply to Thread
Results 1 to 10 of 10

Automatic Backup Every 30 Minutes with Msg Box Confirmation

  1. #1
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Automatic Backup Every 30 Minutes with Msg Box Confirmation

    So we implemented this code thinking that it was backing up our files every 30 minutes and turns out it was not...

    Code located in ThisWorkbook

    Please Login or Register  to view this content.
    Code in Module:
    Please Login or Register  to view this content.
    Can someone please offer a suggestion with a more robust codde or maybe a differnet way to implement this so it doesnt fail?
    Thank you kindly

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    modify Starttimer into this
    Please Login or Register  to view this content.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    thank you bsalv, I will try this.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    Post deleted.
    Last edited by Logit; 11-21-2022 at 11:09 AM.

  5. #5
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    Logit, Yes I need to have the autobackup to be active when the file is open.

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    Post deleted.
    Last edited by Logit; 11-21-2022 at 11:08 AM.

  7. #7
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    you only had to add a "Workbook_Open" macro to lance the "StartTimer", see attachment
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    I am getting a Run Time error '1004' at this line in the Sub StartTime ()

    The error is 'Method 'OnTime', of object'_Application Failed

    Section of code , line 5:

    Please Login or Register  to view this content.
    This is how I implemetned the code:

    This code is inside of my module:

    Please Login or Register  to view this content.

    This section of code is in ThisWorkbook:

    Please Login or Register  to view this content.
    What am I doing incorrectly?

  9. #9
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    you can have only 1 "Workbook_Open", so you have to move that one line
    Please Login or Register  to view this content.
    of Private Sub Workbook_Open1() to the normal "Workbook_Open"
    Please Login or Register  to view this content.
    Also the "cRunWhat" was wrong

    EDIT : an update of the file
    Attached Files Attached Files
    Last edited by bsalv; 11-03-2022 at 09:50 AM.

  10. #10
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Re: Automatic Backup Every 30 Minutes with Msg Box Confirmation

    Oh man I ended up getting a critical error and had to restore the file. Apparently there can be some issues that can happen with the Workbook Open function. Are there any different ways to do this. This is a highly senstive file. I have a love hate relationship with Excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Schedule Automatic Backup
    By wherdzik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2020, 11:11 AM
  2. Something like automatic backup copy...
    By idjundje in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 04-12-2016, 02:38 PM
  3. Automatic backup list
    By buhaj47 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2015, 01:59 PM
  4. save:Automatic Backup
    By Zan03 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2013, 12:41 PM
  5. Automatic Backup
    By jeff p in forum Excel General
    Replies: 2
    Last Post: 03-21-2009, 02:03 AM
  6. [SOLVED] Excel automatic backup location
    By teju in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 06:30 AM
  7. Automatic backup copy
    By craigq in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-11-2005, 01:06 PM

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