Scheduling Macro run
Folks,
I am using the onTimer methods for scheduling the automation of a macro to be run. I need to turn it off from 5:15 to 5:59pm every day and then restart at 6:00pm until 5:15pm the next day. Is there a way to do this? How would you do this? |
Scheduling Macro run
When you schedule it for the next cycle, check the current time, if it is
5:15, set the next time to 6:00pm. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "axwack" wrote in message ... Folks, I am using the onTimer methods for scheduling the automation of a macro to be run. I need to turn it off from 5:15 to 5:59pm every day and then restart at 6:00pm until 5:15pm the next day. Is there a way to do this? How would you do this? |
All times are GMT +1. The time now is 05:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com