Kevin,
In a regular module, try the following:
Sub Auto_Open()
' Following line will call "CloseMe" in 1 minute
Application.OnTime Now + TimeValue("00:01:00"), "CloseMe"
End Sub
Sub CloseMe()
' If you want to save it before closing
ThisWorkbook.Save
' To quit Excel altogether
Application.Quit
' To just close the workbook and leave Excel open
ThisWorkbook.Close
End Sub
John
Kevin wrote:
Does VBA code exist to automatically close a file after a
specified period of time?
Thanks.
Kevin