Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks in advance to anyone who can help me with this.
I have a simple excel macro written and want it to run every so often (5 min / 10 min / 1 hour not sure yet) between the hours of 8:35:00 am and 3:05:00 pm. I have been digging through related topics regarding the OnTime method (here.. http://www.cpearson.com/excel/ontime.htm and here.. http://www.ozgrid.com/Excel/run-macro-on-time.htm as well as many more) and cannot really get my head around the easiest way to do this. Most of my confusion comes from where to write the code whether it be in my current macro module, or in new modules / where and how the sub's and sub of sub's go. Also I have trouble determining what is actual code and what is a field I must define from much of the information that is out there. It would be much appreciated if anyone could help an amateur. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel files, periodically, taking a long time to save or open | Excel Discussion (Misc queries) | |||
Macro running time | Excel Programming | |||
Running a macro at a certain time | Excel Discussion (Misc queries) | |||
All time running macro | Excel Programming | |||
Running a macro at a certain time | Excel Programming |