Hi,
I am using the following code to periodically pause a macro. The problem is, as the system clock runs through midnight, the macro stops working. Any idea of a way to be able to pause through midnight and continue to run later?
Thanks!
Please Login or Register to view this content.
Last edited by JBeaucaire; 03-27-2013 at 02:38 AM. Reason: Added CODE tags. as per forum rules. Don't forget!!
You should read up on the web about the OnTime method. It lets you schedule a macro to run at a certain time in the future. Within the macro you scheduled to run should be additional code to reset the timer again using the OnTime method again. As long as you keep resetting the timer this way, it should run until whatever "test" you've built into your macro stops the process.
The OnTime method lets you set the future time by a specific time, or "x seconds/minutes" in the future. So you could set the timer to run again in "Now + 10 seconds".
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Maybe have a look at this.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks