Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 11-07-2022, 10:17 PM
Bikram Bikram is offline Automatically saving document after each 5 minutes Windows 10 Automatically saving document after each 5 minutes Office 2007
Advanced Beginner
Automatically saving document after each 5 minutes
 
Join Date: Jul 2021
Location: Nepal
Posts: 97
Bikram is on a distinguished road
Default

You could use the following code:
Code:
Sub ActiveDocument_Save()
Application.OnTime Now + TimeValue("00:05:00"), "Savedoc"
Application.OnTime Now + TimeValue("01:00:00"), "Backupfile"
End Sub
Sub Savedoc()
ActiveDocument.Save
Application.OnTime Now + TimeValue("00:05:00"), "Savedoc"
End Sub
Sub Backupfile()
Dim str, name As String
    With ActiveDocument
        str = ActiveDocument.FullName
        name = ActiveDocument.name
        .Bookmarks.Add "CursorPosition", Selection.Range
        .Save
        .Close
        FileCopy str, "D:\Your Desired Location\" & name
        Application.OnTime Now + TimeValue("01:00:00"), "Backupfile"
        Documents.Open str
        ActiveDocument.Bookmarks("CursorPosition").Select
    End With
End Sub
Or you can use gmayor's code which I used to write the above code:
Code:
Sub SaveACopyToFlash()
Dim strFileA As String
Dim strFlash As String
    strFlash = "D"
    If strFlash = "" Then
        MsgBox "User Cancelled", vbExclamation, "Cancelled"
        Exit Sub
    End If
    With ActiveDocument
        .Save 'save the original document
        strFileA = .FullName 'Saved original document name
        strFlash = strFlash & "\" & .name 'Flash drive filename
        .Close 'Close the document
    End With
    On Error GoTo oops 'Error handler for missing flash drive
    FileCopy strFileA, strFlash 'Copy source to flash
    Documents.Open strFileA
    ActiveWindow.View.Type = wdPrintView
    End
    oops:
    If Err.Number = 61 Then
        MsgBox "Disc Full! The partial file created will be deleted", vbExclamation
        Kill strFlash 'Remove the partial file
    Else
        MsgBox "The flash drive is not available", vbExclamation
    End If
        Documents.Open strFileA
        ActiveWindow.View.Type = wdPrintView
End Sub
Reply With Quote
 

Tags
vba autosave document



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically saving document after each 5 minutes Viewable page automatically shifts after minutes ZenHiker Word 1 10-22-2016 01:40 PM
Word is saving open document automatically in its own, Jamal NUMAN Word 4 10-21-2016 01:37 PM
Automatically saving document after each 5 minutes Saving Attachment Automatically emmanpelayo Outlook 5 09-28-2016 04:17 AM
Outlook is continuously & automatically opening (currently 8 screens in 10 minutes) mikef Outlook 0 07-21-2014 01:49 PM
Word 2010 not saving automatically darrylmarshall Word 1 06-07-2012 02:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft