Open another instance of the Browser (IE)

0

I have around 5 IE open (which I don't want to be closed). Problem is, whenever I try to click a new link from within my excel, the link will open on the LAST browser(window) which I have clicked:

ex. Browser 1 - www.yahoo.com

     Browser 2 - www.google.com

     Browser 3 - www.motogp.com

     Browser 4 - www.teachexcel.com

     Browser 5 - www.microsoft.com

supposed the last browser I clicked/activated is Browser 2 (google.com) and try to open/click a new link from my excel (lets say, www.helpmeplease.com), the said link will open in my browser 2...is there a way to make it open in another browser (browser 6)? or if not, is it possible to just make the link open in browser 5? tia.

Answer
Discuss

Answers

0

Try this code:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

ThisWorkbook.FollowHyperlink Address:=Target.Name, NewWindow:=True

End Sub

Put it into the worksheet module that has the links. Just right-click the tab and click View Code to get there.

Update

If you use a macro to go to the url, it seems to work like you want.

Sub OpenIE()

Dim IE As Object

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate "http://google.com"

End Sub

You would just need to make this macro work with your hyperlinks probably using the Worksheet_FollowHyperlink feature.

Discuss

Discussion

Hi, thanks for the quick reply...actually, I'm also using the same code that you mentioned (NewWindow:=True)...alas, I may have "figured" out what's wrong...could it be that I'm using an explorer which doesn't have any tabs?...is there any "workaround", like, actually opening a totally new explorer?...thanks again.
Lhyl Aug 12, '16 at 12:58 am
Answer updated.
don (rep: 1492) Aug 16, '16 at 12:42 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login