Need help with VBA code for google API

[gdamato]

Hello all,

I have a spreadsheet that uses a google distance API which calculates the distance between two points.

I'm trying to accomplish 2 things:

#1 - The API I use, someone gave me online somewhere a while back. I haven’t used it in a while and am now running into issues with query limits. Yesterday I got my own API Key from google, only I don’t know where to place it in the API coding for it to work properly (so google know's it's "me")

#2 - Google limits the amount of queries you can do with their APIs (per second & per day). This coding asks for DISTANCE which is the only thing I need. It also asks for directions and travel time which I do NOT need. I'd like to remove that coding so it doesn't count as a query against me.

Thanks in advance for ANY help you can provide!

Please Login or Register  to view this content.

[CK76]

1. You'll need to implement OAuth2. Read through link below for details.
http://ramblings.mcpher.com/Home/exc...s/googleoauth2

2. From the looks of it, it's single request/query that returns all the results for single set (i.e. from starting address to destination, it has distance, direction & travel time in single response). So you probably don't have to worry about that. Rather limit is how many starting point and destination you query.