View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_7_] Gareth[_7_] is offline
external usenet poster
 
Posts: 28
Default continual updating

You're welcome - thanks for letting me know.

Note that I just spotted I should have written:

'work out when you want the next update to take place
myOnTime = Now + Timeserial(0,SyncFreqInMinutes ,0)

rather than

'work out when you want the next update to take place
myOnTime = Now + Timeserial(0,1,0)

Of course it will still work the same - since SyncFreqInMinutes was set
as 1 anyway - but it you want to change the frequency to 2 or 3 minutes,
say, you just change the constant SyncFreqInMinutes to 2 or 3 etc. And
of course you could always change it to work with seconds.

G

dok112 wrote:
it works beautifully! THANKS!!