Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default Max number of runs in a time period?

How can I make sure, that af macro is only executed 50 times during the last
hour?

I.E.
If I call the macro for the 51. time, and it has only been 45 minutes since
I called the macro for the first time, the macro will pause for 15 minutes
before continue, ensuring that I always only run the macro max 50 times
during an hour.

And, if I then call the macro for the 52. time, and it has only been 20
minutes since I called the macro for the 2. time, the macro will now pause
for 40 minutes.


How to make sure that a macro in only called/execute max 50 times during the
last 60 minutes?


TIA,


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of dates between a specified period of time Sodak Excel Worksheet Functions 2 December 17th 09 02:35 PM
number of week days in a period of time Erol Excel Worksheet Functions 5 July 30th 09 07:43 PM
add number of days within a department for a given time period Ralph D''Andrea Excel Worksheet Functions 3 October 3rd 07 09:21 PM
average rate of change per given time period between 2 moments in time of a value David Virgil Hobbs Excel Programming 1 December 19th 06 07:24 AM
Every time i put a number with period it becomes a date and time excelSOS Excel Discussion (Misc queries) 7 March 7th 06 12:20 AM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"