Folks:


I am looking for some ideas to complete this spreadsheet task via an excel
function or any other technique. Here is the issue.

I have an excel spreadsheet containing 100 HTML hyperlinks that MAY
successfully launch windows media player to play associated video/audio
files.
Manually, I can click on my links and the Windows media Player MAY launch
and play the associate media file IF THAT FILE IS FOUND

I want to write a program/macro to click on (run) the hyperlink in each
cell.
If the media file is found, I want to write "1" in the adjacent cell. If
NOT found I want to write "0" in the same adjacent cell

If the media file is found I want to stop the playing, just before moving on
to the next cell.
If the media file is NOT found I want to click (OK) on the popup window that
appears, before moving on to the next cell

Now use a LOOP to move to the NEXT then NEXT cell until all are done.




Thanks,
John.