Query Google maps to return driving distance and time

Hi all,

I've been looking at the thread below and trying to get the function to return the driving distance and time just as thegooser123 required in his original post. Unfortunately it's not working anymore. Does anyone know of a way to fix it?

http://www.excelforum.com/excel-gene...g-times-2.html

I've attached a copy of the workbook with the most recently suggested functions in the VBE by Domski.

Many thanks


Mick