+ Reply to Thread
Results 1 to 7 of 7

Macro to save automatically excel sheet in every 2 minutes

  1. #1
    Registered User
    Join Date
    09-24-2011
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    64

    Macro to save automatically excel sheet in every 2 minutes

    Hi

    I need a macro by which my excel file should save in every 2 or minutes so that I never lost my work in I forget to save.

    Please do the needful. i would like to mention here that I work in US Eastern time zone.

    Thanks & Regards,
    Javed Khan

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Macro to save automatically excel sheet in every 2 minutes

    Hi,
    is there any reason not to use the standard autosave option?
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Registered User
    Join Date
    09-24-2011
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Macro to save automatically excel sheet in every 2 minutes

    I will give you the reason...but first I would like to tell you that in my office people some time forget to save ( CTRL+SAVE) their MIS and consequnce " Data get lost" .

    Reason is that standard autosave option does not work there.

    plz help.

    Thanks

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro to save automatically excel sheet in every 2 minutes

    Hi bittu2010
    Please Login or Register  to view this content.
    Last edited by jaslake; 02-11-2012 at 07:44 PM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Registered User
    Join Date
    09-24-2011
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Macro to save automatically excel sheet in every 2 minutes

    Hi,

    Sorry to say but this macro is not working in my sheet or may be I am not able to understand where should I save this macro.

    I request you to give me a excel sheet attached with this macro.

    I want that my excel mis should save in every 2 minutes.

    Thanks

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro to save automatically excel sheet in every 2 minutes

    Hi bittu2010
    File attached
    Attached Files Attached Files

  7. #7
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Macro to save automatically excel sheet in every 2 minutes

    Please keep it simple

    'In the ThisWorkbook Module

    Please Login or Register  to view this content.
    'In a General Module

    Please Login or Register  to view this content.



+ 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