If you have the need to open a bunch of links with Excel, just use this simple VBA macro to open them all in your default browser after they have been selected in Excel. There’s also a 3 second wait step built in, but you can just remove that to open all your links as fast as your system allows.
Sub openSelectedLinksWithDelay()
For Each cell In Selection
cell.Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=False
Application.Wait (Now + TimeValue("0:00:03"))
Next cell
End Sub
For Each cell In Selection
cell.Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=False
Application.Wait (Now + TimeValue("0:00:03"))
Next cell
End Sub