Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-04-2022, 12:24 AM
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 Automatically saving document after each 5 minutes

Greetings, I was trying to save my documents if the document was not saved for more than five minutes. I went this far but it is not dynamic enough. How can this be modified to get the job done? Thanks in advance!!
Code:
Function lastsavetime(de As Boolean)
Dim bb As String, curt As Date, curr, intt As Integer, inttt As Integer, last As Date

curt = Now()

    intt = InStr(1, curt, ":")
    curr = Mid(curt, intt + 1, 2)
    last = ActiveDocument.BuiltInDocumentProperties("Last Save Time")
    inttt = InStr(1, last, ":")
    bb = Mid(ActiveDocument.BuiltInDocumentProperties("Last Save Time"), intt + 1, 2)
        If CInt(bb) - CInt(curr) >= 5 Then
            de = True
        End If

End Function

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 01:20 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