Prev: Comment in every 10 the row
Next: if else if...
From: Eric on 11 May 2010 08:37
I am using Excel 2003.
Once I open a workbook, I would like to close it after 15 mins automatically.
Does anyone have any suggestions on how to code it in macro?
Thanks in advance for any suggestions
Eric
From: Mike H on 11 May 2010 08:48
Hi,

Here's a nice simple way

http://www.ozgrid.com/forum/showthread.php?t=42169
--
Mike

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


"Eric" wrote:

> I am using Excel 2003.
> Once I open a workbook, I would like to close it after 15 mins automatically.
> Does anyone have any suggestions on how to code it in macro?
> Thanks in advance for any suggestions
> Eric
From: Dave Peterson on 11 May 2010 10:19
Saved from a previous post:

So you would want to force the user to close the file -- even though you don't
know if the current changes should be saved or discarded?

That sounds like a disaster for you, your co-worker, and your boss -- who's
going to be upset that something got saved that shouldn't have -- or 8 hours of
work was discarded and shouldn't have been.

I think that this is a training issue.

But if you look at Chip's site to see how to close a workbook after a given time
of inactivity.

http://www.cpearson.com/excel/TimedClose.htm

(I can't say how much I think that this is a bad idea!)

Eric wrote:

> I am using Excel 2003.
> Once I open a workbook, I would like to close it after 15 mins automatically.
> Does anyone have any suggestions on how to code it in macro?
> Thanks in advance for any suggestions
> Eric

--

Dave Peterson
From: Peter T on 11 May 2010 10:56

"Dave Peterson" <petersod(a)XSPAMverizon.net> wrote in message news:%
> Saved from a previous post:
>
> So you would want to force the user to close the file -- even though you
> don't
> know if the current changes should be saved or discarded?
>
> That sounds like a disaster for you, your co-worker, and your boss --
> who's
> going to be upset that something got saved that shouldn't have -- or 8
> hours of
> work was discarded and shouldn't have been.
>
> I think that this is a training issue.
>
> But if you look at Chip's site to see how to close a workbook after a
> given time
> of inactivity.
>
> http://www.cpearson.com/excel/TimedClose.htm
>
> (I can't say how much I think that this is a bad idea!)

I think you just did <g>

Peter T


From: Eric on 11 May 2010 12:22
When I edit the file, which usually take less than 30 mins, then I will save
and close it manually. On the other hands, I set schedule task to open
specific file at specific time for reading only, therefore saving it before
closing is good for me.
I don't know whether I work on this file or not, once this file opens based
on schedule.

Once this file is opened at 10 am, I am still working on this file for 45
mins, and finish at 10:46 am. This file should not be automatically saved
and close at 10:31 am, because it does not inactivity for 10 mins. On the
other hands, if this file is inactivity for 10 mins after 30 mins, the this
file should be saved and close at 10:56 am.
For example,
1) Once this file is opened at 10 am, it should be saved and close at 10:31
am and inactivity for 10 mins between 10:21 am and 10:31 am.

2) if file is inactive starting at 10:22 am, this file should be saved and
closed at 10:32, because it passes the first 30 mins and inactivity for 10
mins since 10:22 am.

3) if file is inactive starting at 10:36 am, this file should be saved and
closed at 10:46, because it passes the first 30 mins and inactivity for 10
mins since 10:36 am.

Does anyone have any suggestions on how to add this condition to macro coding?
Thank everyone very much for any suggestions
Eric


"Dave Peterson" wrote:

> Saved from a previous post:
>
> So you would want to force the user to close the file -- even though you don't
> know if the current changes should be saved or discarded?
>
> That sounds like a disaster for you, your co-worker, and your boss -- who's
> going to be upset that something got saved that shouldn't have -- or 8 hours of
> work was discarded and shouldn't have been.
>
> I think that this is a training issue.
>
> But if you look at Chip's site to see how to close a workbook after a given time
> of inactivity.
>
> http://www.cpearson.com/excel/TimedClose.htm
>
> (I can't say how much I think that this is a bad idea!)
>
> Eric wrote:
>
> > I am using Excel 2003.
> > Once I open a workbook, I would like to close it after 15 mins automatically.
> > Does anyone have any suggestions on how to code it in macro?
> > Thanks in advance for any suggestions
> > Eric
>
> --
>
> Dave Peterson
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Comment in every 10 the row
Next: if else if...