View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Ontime problem; variable not passed from Workbook_Open to Star

What about my suggestion?

--
__________________________________
HTH

Bob

"thomas" wrote in message
...
Bob,

Based on the current code, it will run at 9.15. The 15 minute interval is
working beautifully. 'MsgBox "FirstTimer is " & FirstTime' placed in the
StartTimer before "If FirstTime Then" always return false regardless of
the
time.



"Bob Phillips" wrote:

How about adding a test that if it is opened between 9:00 and 9:15, run
the
macro and schedule the next at 9:15.

--