Excel windows media player links

[JohnNews]

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.

 

[Tom Ogilvy]

Just extract the file information from the link and use dir to see if it
exists.

 

[JohnNews]

Tom:


Thanks; but that may not be possible. The hyperlinks that I am accessing,
all have the following formats:

http://Johnen.stream.com/mcasx.asx?media=2764375&system=4536760


The only thing that changes when we move to the next cell is the FIRST
numeric string.
Now I do not know the value of this numeric string, so I have to put in
various test values then check to see if they work


Thanks,
John.