View Single Post
 
Old 02-21-2017, 03:05 PM
dwirony dwirony is offline Windows 7 64bit Office 2003
Advanced Beginner
 
Join Date: Oct 2016
Posts: 49
dwirony will become famous soon enough
Default

Try:

Code:
Public Sub FileSave()
ActiveDocument.ActiveWindow.Visible = True
ActiveDocument.Save
DoEvents
Application.OnTime _
When:=Now + TimeValue("00:05:00"), _
Name:="FileSave"
Application.StatusBar = "Saved: " & ActiveDocument.Name
ActiveDocument.Close
Application.Quit
End Sub
I believe this solution will work to save the one active document. Are you trying to save and close ALL documents on your computer at the specific time? In that case, you'll probably need some sort of loop to go through each document and save them. And that's beyond my knowledge of VBA :S

Last edited by dwirony; 02-21-2017 at 03:08 PM. Reason: Incorrect solution
Reply With Quote