The code snippet I posted simply uses the standard Shell command to start a browser and navigate to a page. You cannot directly manipulate the data on that page, and, as I mentioned, you cannot automate Chrome with VBA - as far as I'm aware...
You'll make your life a whole lot simpler if you use IE for this.
Try this (as a sampler)
Run it with the sheet containing the hyperlinks as the activesheet.
Public Sub Navtest()
Dim ie as Object
Set IE = CreateObject("InternetExplorer.Application")
ie.visible = true
Dim x as integer
Dim links as Hyperlinks
Set links = ActiveSheet.Hyperlinks
For x = 1 to links.count
ie.navigate links.item(x).address,nothing, "_blank"