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.

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

--
Regards,
Tom Ogilvy

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