Prev: Opening two workbooks
Next: Need a UDF to count blank cells
From: Robert Crandal on 22 Feb 2010 02:42
Is it possible (or even wise) to automatically close and
save a workbook after a couple minutes of idle time???
If so, how would you implement the timer?

thank u

From: Mike H on 22 Feb 2010 04:39
Hi,

> Is it possible

Yes have a look here
http://www.ozgrid.com/forum/showthread.php?t=42169

> Is it wise

Only you can decide. In this portion of the code I've pointed you to you
will need to make a decison, Save or Not Save

Sub CloseMe()
Application.DisplayAlerts = False
ThisWorkbook.Close savechanges:=True ' or false, you choose
Application.displayalerts = True
End Sub

If you don't save what are you discarding=danger
If you do save what garbage are you keeping=danger
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Robert Crandal" wrote:

> Is it possible (or even wise) to automatically close and
> save a workbook after a couple minutes of idle time???
> If so, how would you implement the timer?
>
> thank u
>
> .
>
 | 
Pages: 1
Prev: Opening two workbooks
Next: Need a UDF to count blank cells