Question of updates

[bondcrash]

I have an external feed that updates every second. However sometimes it loses the connection without me knowing. Is there a way to alert me when this happen? I.e, I need to know when the cell stops updating (it stas frozen on the last value) , preferably having another cell change when that happens (so that I can apply a conditional formatting on it or play a sound).

Many thanks

BC

[Tom Ogilvy]

there is API code around that could be used to test the connection, but if
the value changes on each update, you could use a public variable to store
the last value an another to store the number of times it has remained the
same, Then check it perhaps every two seconds using application.Ontime

See Chip Pearson's page on Application.Ontime
http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"bondcrash" <[email protected]> wrote
in message news:[email protected]...
>
> I have an external feed that updates every second. However sometimes it
> loses the connection without me knowing. Is there a way to alert me
> when this happen? I.e, I need to know when the cell stops updating (it
> stas frozen on the last value) , preferably having another cell change
> when that happens (so that I can apply a conditional formatting on it
> or play a sound).
>
> Many thanks
>
> BC
>
>
> --
> bondcrash
> ------------------------------------------------------------------------
> bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
> View this thread: http://www.excelforum.com/showthread...hreadid=394560
>

[bondcrash]

thanks Tom

BC