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"