JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,233
- Office Version
- 365
- Platform
- Windows
Hey All
What I'm trying to do is use Excel to open 4 different instances of the default browser, each with a different URL
So, in Cell A1 I've got something I want to search for.
I want to be able to click a button and open 4 different browser windows, one going to Google, one going to Bing etc etc
Normally I just use FollowHyperlink when I just want to open a website but it just adds new tabs instead of new windows, even if I specify NewWindow
I've Googled and found other code that does it through shell commands but that does the same thing, just adds more tabs.
Can anyone help at all?
Thank you.
What I'm trying to do is use Excel to open 4 different instances of the default browser, each with a different URL
So, in Cell A1 I've got something I want to search for.
I want to be able to click a button and open 4 different browser windows, one going to Google, one going to Bing etc etc
Normally I just use FollowHyperlink when I just want to open a website but it just adds new tabs instead of new windows, even if I specify NewWindow
VBA Code:
Sub TestSearch()
ActiveWorkbook.FollowHyperlink Address:="https://google.co.uk", NewWindow:=True
ActiveWorkbook.FollowHyperlink Address:="https://bing.co.uk", NewWindow:=True
End Sub
I've Googled and found other code that does it through shell commands but that does the same thing, just adds more tabs.
Can anyone help at all?
Thank you.