Opening Multiple URL's via Excel

[jimmybangs]

Hi,

I don't know if anybody here uses URLopener.com (a free web app to download multiple URLs in seperate tabs in a web browser)?? But last night mysteriously it went down and cannot find an alternative for it on the web.

Does anybody know of a Macro that would take a list of URLs (in a vertical list - A1,B1,C1...and so on) in a xls and open them in them in seperate tabs in Firefox, IE etc?

Cheers,

Jim

 

[RolfJ]

Assuming that you mean by 'vertical list' a range of cells from A1 to An (not A1, B1, C1... which really is a horizontal list), this macro should do what I think you would like to do:

Sub LaunchMultipleURLs()
    Dim r As Range
    Set r = Range("A1:A3")
    Dim c As Range
    For Each c In r.Cells
        c.Hyperlinks(1).Follow NewWindow:=True
    Next c
End Sub

Hope this helped,
Rolf

 

[jimmybangs]

Cheers Rolf,

This is really useful! Thanks again,

James

 

[chuckro84]

This stopped working when I used it on a new spread sheet and keeps saying the issue is: "c.Hyperlinks(1).Follow NewWindow:=True".

It worked perfectly before. Any ideas why this is not working on the next URLs?