LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Running a Macro periodically between Time A and Time B

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
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
Excel files, periodically, taking a long time to save or open mavio Excel Discussion (Misc queries) 0 October 16th 09 04:43 PM
Macro running time Pradip Jain Excel Programming 2 April 22nd 05 01:50 PM
Running a macro at a certain time Tam Excel Discussion (Misc queries) 3 March 2nd 05 02:50 PM
All time running macro gocush[_29_] Excel Programming 2 January 12th 05 03:19 PM
Running a macro at a certain time Dave Peterson[_3_] Excel Programming 0 October 17th 03 01:49 AM


All times are GMT +1. The time now is 03:28 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"