Software

Ask something
Question Locked

About Hyperlinks

0 helpful
3 replies

by ande187

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a problem and i believe someone else has this too. I have an excel file which contains near 600 hyperlinks to different websites. But my problem is i cant open more than 1 hyperlink at the time and in that way going trough 600 websites would take like 4days, is there any program / Software, plug in, or ANY way open Many hyperlinks same time so i dont need to click 1 after 1?

Please contact to my E-mail ande187@hotmal.com
-THANKS-

3 replies

by fwang

Assume your hyperlinks are in column A and start from row 2, then you can write a small macro like:

Sub OpenUrl()
Dim r As Integer

r = 2
Do
Cells(r, 1).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
r = r + 1
Loop While Cells(r, 1).Hyperlinks.Count
End Sub

This will open all the urls start from row 2 until it hit a blank cell.

If you are using IE7, each url will be opened in a tab. Otherwise, try to use NewWindow:=True to open each url in a new window.

Keep in mind, open 600 urls at the same time will take a long time and lots of system resource. Wish you have a good machine.

by marcusd

I use one tool that maybe can help you. Application is called ReplaceMagic and you can find it on www.replacemagic.com

I used tool for big files migrations where links where broken. It supports changes in hyperlinks, OLE object links and texts in different parts of documents.

For me it was extremly usefull.

Regards,
Marcus

This discussion is closed to new replies.