macro to open hyperlinks

**abuchan** · 03-01-2010, 11:28 PM

This could be considered part 2 to my previous post which was solved quite nicely. In searching the net, it seems that it may be possible to determine which of the created hyperlinks are real (active). I just used the script and it worked well but sitting and clicking goes on and on. The first link that worked was try 406.

Is it possible to create a macro which goes through the hyperlinks and finds which, if any, are currently active?

I have a list of 676 hyperlinks on Sheet 2 as shown in the previous post.

Much appreciated.

I am attaching the file from the previous post as well as the script which was amended ( magically by Pike) to create the hyperlinks.

Thanks again, again.

Please Login or Register  to view this content.

Please note that the "022510" is a date.

**Leith Ross** · 03-01-2010, 11:38 PM

Hello abuchan,

To which script are you referring?

**abuchan** · 03-01-2010, 11:49 PM

Thanks Leith.

I have provided the script as well as the sample file. However, now thinking about it, none of the results will be active. If you want an active file please private message me as I don't think I should publish it.