VBA code to return URL of webpage after redirected URL

[SR1]

Hi,

I was wondering it was possible to return the URL of a webpage after a redirected hyperlink.

Basically, if you open any of the following hyperlinks in Google Maps based on the left hand column:

83 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/83 ABBEY AVENUE WEMBLEY HA0 1LJ
85 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/85 ABBEY AVENUE WEMBLEY HA0 1LJ
87 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/87 ABBEY AVENUE WEMBLEY HA0 1LJ
89 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/89 ABBEY AVENUE WEMBLEY HA0 1LJ
91 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/91 ABBEY AVENUE WEMBLEY HA0 1LJ
93 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/93 ABBEY AVENUE WEMBLEY HA0 1LJ
95 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/95 ABBEY AVENUE WEMBLEY HA0 1LJ
97 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/97 ABBEY AVENUE WEMBLEY HA0 1LJ
99 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/99 ABBEY AVENUE WEMBLEY HA0 1LJ
101 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/101 ABBEY AVENUE WEMBLEY HA0 1LJ
103 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/103 ABBEY AVENUE WEMBLEY HA0 1LJ
105 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/105 ABBEY AVENUE WEMBLEY HA0 1LJ
107 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/107 ABBEY AVENUE WEMBLEY HA0 1LJ
109 ABBEY AVENUE WEMBLEY HA0 1LJ https://www.google.co.uk/maps/place/109 ABBEY AVENUE WEMBLEY HA0 1LJ


It will produce a somewhat different URL that includes the geographic coordinates, eg for 83 Abbey Avenue you will get:

https://www.google.co.uk/maps/place...4ace4558c2c956e!8m2!3d51.5357058!4d-0.2929376

I want to be able to get the new URL so I can extract the coordinates from it, is this possible?