Open a new chrome window after every 40th hyperlink

[RecordMan]

Hi guys,

I have a long column of links that I'm looking through.
I put together a VBA script that opens 40 hyperlinks from the cells I've selected, and then pauses with a message box before doing the next 40.

I'd really like for it open a NEW chrome window when the script begins, and everytime it opens the next 40 links.
Looked around google but couldn't find anything that worked.
I'm on a mac, the file path to Chrome is SYSTEM/Applications/Google Chrome.app

Is there some simple attribute for FollowHyperlink or something I can use?
Apologies if not making much sense - Haven't done any VBA for ages, very rusty.

Below is the sub I'm running. Works fine and I just open a new window manually at start and before proceeding to next 40 hyperlinks.
But would be great if someone knew what code I can just shove in there to automate the new window thing?

Cheers,
Dan

Please Login or Register  to view this content.

[pjwhitfield]

normally in HTML you would add

Please Login or Register  to view this content.

to a hyperlink to open a new window, you can do this via VBA as well

https://learn.microsoft.com/en-us/of...perlink.target