Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.

excelmacros-vbainternet-web
MS Office Version: 2010
posted by: Lhyl on Thu Aug 11, 2016 at 8:16 pm
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.

posted by: don (rep: 1989) on Thu Aug 11, 2016 at 11:29 pm
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: 1989) 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