Need a VBA Macro to calculate distance between two cities in Australia using google maps

Hi Guys,

Kindly help me with a VBA macro to find distance between two cities in Australia using google maps as I have more than 1000 cities to lookup.

In cell A2 has the first city name (Grafton, Australia) and cell B2 has the destination (Queanbeyan, Australia). The distance between the first and second city needs to be checked in maps.google.com and return the distance in the cell C2.

I need this help as it is difficult to look up more than 1000 entries.

I am using Excel 2010 and IE 10.

I am new to excel and VBA. Please help.

Regards,
Joe