How can I Batch open Hyperlinks to URLs in tabs of my browser?

[robgoldstein]

I need to batch open some hyperlinks from a long list of hyperlinks in my excel sheet. I would like these to each open in a new tab of my web browser.
Is there a way to do this?

 

[zapperX]

If you know the cell locations of the links, this macro will do it...

For Each c In Worksheets("Sheet1").Range("A9:A11").Cells    c.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Next

that macro assumes you have links in cells A9,A10 and A11 in Sheet1.
kevin

 

[robgoldstein]

Thanks so much. I just tried using that, and the macro won't run. I just cut and pasted it. Is there anything else I need to do?

 

[zapperX]

how did you run it?

 

[robgoldstein]

I went to the developer tab, then clicked on VB, then went to the view menu and clicked on code, then pasted it in. I then changed the cells and clicked on the Run button.

This is what I have done with other macros i have been given. I a total novice on VB and macros.
thanks so much for your help.

 

[zapperX]

from the developers tab, click Macro, when the dialog open, enter a name for a new macro and click Create. The VB editor will open with a sub routine for your marco. Paste the code in there. Also there is a slight typo in the code above... it should be

[COLOR=#333333]For Each c In Worksheets("Sheet1").Range("A9:A11").Cells
    c.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
[/COLOR][COLOR=#333333]Next[/COLOR]

HTH
kevin

 

[robgoldstein]

You are the best. thanks so much. that is exactly what I needed.