Checking for broken URLs

Hello,
I have an excel sheet with several hundred URLs, which I need to check if are broken.
I'm having difficulties finding a function which would do exacly that, check if a file over a site (http://...) is still valid or reports a broken link. All the sites are sites over the local network.

I've tried using both the FileSystemObject and Dir function, and still came up with nothing.

Any way I can modify one of those commands or an alternative way to suit my needs?

Thanks a lot.

It returns false every time, and I can see it reaches the end of the case switch as I tried changing the message in the iif part.
Maybe it's due to the fact that they're microsoft sharepoint sites? Or a slow network resulting the status not being resolved in time?

Thanks a lot

Thanks a lot for all your help.
I'll try and get it using some trial and error and the microsoft help sections.

Originally Posted by shg

Try this:

Please Login or Register  to view this content.

So I may be reviving a dead horse here, but I have essentially the same problem. However, my urls are not local network. Either way, I copied and pasted the above Macro exactly as written, but when I open the Run Macro feature, it won't show the Macro as an option to run. What am I doing wrong?