Opening Multiple URL's via Excel

jimmybangs

New Member
Joined
Nov 28, 2008
Messages
36
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

RolfJ

Banned
Joined
Jul 29, 2009
Messages
333
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:

Code:
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
 

chuckro84

New Member
Joined
Jul 2, 2014
Messages
1
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,176
Messages
5,600,140
Members
414,365
Latest member
UUR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top