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

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" wrote
in message ...

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

thanks Tom

B

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=39456