![]() |
#9
|
|||
|
|||
![]()
this took way too long to figure out, but it is remarkably simple in hindsight, so here it is
in VBA in the main ThisDocument page put : Option Explicit Private Sub Document_Open() CheckTime End Sub then, add a module, containing the following : Option Explicit Dim PreviousContent As String Sub CheckTime() PreviousContent = ActiveDocument.Content Application.OnTime When:=Now + TimeValue("00:10:00"), _ Name:="DoCompare" End Sub Sub DoCompare() If ActiveDocument.Content = PreviousContent Then 'if no changes after 10 minutes, save then close the document ActiveDocument.Save ActiveDocument.Close Else CheckTime End If End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to dectect if close document and now no document open | skarden | Word VBA | 2 | 10-24-2022 07:03 AM |
![]() |
Joe528 | Word | 3 | 10-08-2021 06:12 PM |
Document close if/then/else error | eduzs | Word VBA | 1 | 01-02-2021 05:56 AM |
Save and Close powerpoint if it is inactive | MetteGaga | PowerPoint | 0 | 04-16-2015 05:14 AM |
Prompt when close the document | ubns | Word | 15 | 04-29-2012 10:07 PM |