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!!
|