Using Now Time- to avoid file read/write to file at same time

[dantheman9]

Im sure this should be easy to work out, but just after some advice on it!
I have a sub which runs every 10 mins using Now Time +10 mins, this sub wirtes a new html file.

The html file has a meta refresh tag - to refreah every 20 mins.
Trouble is, I need to avoid any conflict from the two (the sub rewirting the file, at the same time as the page refresh).

What would be the best way to stop this (would it be best to set the sub update from a time stamp from the html creation?).

any ideas would be much help!!!

thanks

 

[Comfy]

You could add the following to you Sub so that it doesnt execute on the 20 minute interval

If Minute(Now()) = "20" Or Minute(Now()) = "40" Or Minute(Now()) = "0" Then
'Have then have the Sub Quit and re-run in a minutes time
Else
'Run Your Code
End If

Now that I posted that I see that your code may not necessarily be executed on the hour and then 20 mins after that

 

[dantheman9]

thanks comfy,

yeah the second update won't be picked up by the html refresh - as it will still have 10 mins to go....for the time going I have alter the Sub command to run at old numbers, while keeping the html at evens - hopefully that could be ok for 8 or so hours (taking into acount 10 or so seconds for the sub to run.)

Cheers

Dan