Open a new window in Chrome with VBA.

[fanof]

Hi all,

I have an URL that is in a cell and I would like to open a new chrome window with that URL using VBA.
I wrote the below program that works except it opens the URL in a new tab of an already open window rather than in a new window...

Sub test5()

ActiveWorkbook.FollowHyperlink Address:="https://www.Microsoft.com", _
        NewWindow:=True
End Sub

Can someone help me understand with it does not open a new window? I can't understand.
NB: I use a Mac. I found a couple of programs online that open can do that with window but I have never been able to make them work on my mac...

Thanks!

 

[Jim Gordon]

Hi
The request for a new window is being ignored by your browser. I tried with Microsoft Edge, which is a Google browser in disguise, and the new page opened in a new tab, not a new window. When I set Safari as my default browser, the new page opened in a new window. It looks like Google has made the decision to make the decision for you. I did not find a setting in Edge/Chrome that looked promising to follow your code's instruction.

 

[fanof]

Hi Jim, Thanks you very much for investigating. At least I know it does not come necessarily from my code...
Thanks!