Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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?



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
Scheduling Matt Excel Discussion (Misc queries) 0 May 13th 10 05:34 AM
Scheduling SteveD Excel Worksheet Functions 1 March 18th 08 06:15 PM
Scheduling a Macro to Run Lost and Looking for Help Excel Programming 6 May 16th 06 06:07 PM
Scheduling Matt Excel Worksheet Functions 2 March 15th 05 02:36 PM
Scheduling a Macro Jeff M[_3_] Excel Programming 0 August 18th 03 03:03 PM


All times are GMT +1. The time now is 07:21 AM.

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

About Us

"It's about Microsoft Excel"