User idle

[KausBorealis]

Hi all,

I wrote a program to control the exam of my students.
The student is expected to click on cells, each click is an answer.
With the event "Selection change" a program starts and
asks if in the active folder a file with a special name (say
STOPIT.TXT) was created by the tutor or not.

If created the exam stops.

What to do if the student stops his work and will not make any event?
(Now we ask the student to do something, for example to click anywhere.)


The OnTime is not OK, because during the exam something may happen what
I did not see in advance. (no definite stop time) It must be a momentan decision of the teacher what time is the closing time. Then the tutors program creates a file
what should be noticed by the students program.

Any proposal for an event?


Thanks in advance

Kaus Borealis

[foxguy]

I didn't quite understand what you want. I think it's the same problem I had.

You don't want an OnTime sub to run if some event occurs after the time was set, but before the OnTime sub had run. I solved that with this:

Please Login or Register  to view this content.

So you run SetOnTimeSub to have it run "CheckExam" one hour from now, but if the cursor is moved in any worksheet in the workbook it turns off the OnTime.

If that's not what you wanted, then please try again to explain what you want.

[KausBorealis]

Thanks for the letter, but my problem is different.
If I can hope any event from the user (student) I know what to do.
But in fact a teacher at a different computer makes something
which should be noticed by the student's computer as an event.

The action of the teacher is to create a text file with a special name
in a network folder which folder is a default folder for the student's
computer.

But the student may be idle.

Kaus

[foxguy]

All right;
The teacher creates a file. You want the student's computer to recognize that a file has been created despite the fact that the student's computer is not doing any thing (No Event is being executed).
I'm pretty sure that you will have to use OnTime. Events only occur if something happens. If nothing happens there is no Event.

Something like this is what you want:
The easiest place to put something that starts checking for a file is in the SelectionChange() event. Possibly in the Calculation() event.

Please Login or Register  to view this content.

[KausBorealis]

Thanks foxguy

I'll try it.

Kaus