Everyone

Thanks for believing that I am not trying to do anything sinister and suggesting some probable solutions. Greatly appreciated.

CarlA
Your suggestion solution is what I am looking at implementing on Tuesday. I am not at work tomorrow and I don't have the file at home.

A couple of questions though :-

1. Wouldn't it be required to have this onTime method inside the innermost loop since I want it to be repeatedly called if the procedure inside the innermost loop takes more than say 10 minutes.

2. Having done that, do I just need to specify the "schedule" parameter with the "Now() + 10 minutes" (obviously appropriately coded) or do I also need to specify the latest time as well.

3. Do I need to first have the "DoEvents" statement before the onTime method statement to yield the control the Windows system for the onTime method to execute or this happens by itself?

The reasons that I ask these are as follows :-

The required processing is to be done for 24 months for each of the 7 states in each of the 2 worksheets - that is why it takes so long to complete. The processing time for each month progressively increases since it has to look back as the processed data for all the months prior to the month being processed. Hence, at the start, the processing time may not exceed 10 mins but as we get to the month number 15 and beyond it might start to take around and over 10 minutes.

Now,if I did as above, in those instances where the procedure in the the innermost loop completes in less than 10 minutes, what would happen to the the unexecuted onTime method procedure that was set to run at the expiration of the 10 minute period? Would it get executed when the elapsed time reaches 10 minutes or it doesn't get executed at all - not that it will make a world of a differnece because all I am intending to do in the onTime method procedure is press and release the say "Start/Menu/Windows" key.


Thanks, in anticipation.


Best regards


Deepak