What i would like to do is as long as the workbook is open i want it run a subroutine at 10 min intervals.
Thanks.
Graeme
What i would like to do is as long as the workbook is open i want it run a subroutine at 10 min intervals.
Thanks.
Graeme
You need to use the Ontime Method, see the example code here
http://www.excelforum.com/showthread...ghlight=ontime
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks