VBA code to return travel time (Driving, walking & public transport) between 2 postcodes from google maps.

[AshG1990]

Can someone please help me with this.

I'm at my wits end, I've tried the whole Google API solution with major issues, code was correct but it just seemed to crash when running the macro, could step through it and it worked perfectly.

So I think my next avenue of attack is navigating Internet Explorer and entering my postcodes and retrieving the travel time this way. Can anyone help me as to the code to do this?

I know how to launch and navigate to a website but I struggle when searching for the correct div classes etc...

Trying to turn this around tonight if possible.

Any help will be much appreciated and thanks in advance.

 

[RedBeard]

This works for me: http://analystcave.com/excel-calculate-distances-between-addresses/

 

[AshG1990]

Hi RedBeard,

Thanks for the reply. Does this have any limits? As stated when I was using the Google API previously, I needed it to go through approximately 900 time calculations in which it'd just crash.

Any further help will be much appreciated.

Regards,

Ash

 

[RedBeard]

Google limits the amount of free queries to the following:


100 elements per query.
100 elements per 10 seconds.
2 500 elements per 24 hour period.

So you probably tried with too much data.

 

[AshG1990]

Yeah I think that's the issue, so do you know how I can do it via launching IE and doing it that way. As said in my post, I know how to launch it and navigate to maps but I'm not sure which tags to find and stuff.

Regards,

Ash

 

[RedBeard]

Not me, sorry.

 

[AshG1990]

Okay thanks. Anyone else please?