[AccessD] Automating Google Maps

[John Colby]

Thanks.

On Tue, Mar 14, 2023 at 7:09 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> BTW, if you are going the API route, you should also get Postman:
>
> https://www.postman.com/downloads/
>
>  as it can be very helpful in exploring and testing out calls to API's.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Jim Dettman via AccessD
> Sent: Tuesday, March 14, 2023 6:39 AM
> To: 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com>
> Cc: Jim Dettman <jimdettman at verizon.net>
> Subject: Re: [AccessD] Automating Google Maps
>
>
>  I've done some.   Used a web browser control to allow users to pin-point a
> location, then got a lat/long for distance calculations from the returned
> URL string.
>
>  That was a fly under the radar type of thing as the client didn't want to
> pay for the API calls (most sites charge for you to use their API based on
> usage).
>
>  If you are going to call the API directly, then I would use the VBA WEB
> lib:
>
> https://github.com/VBA-tools/VBA-Web
>
>   While you can set a ref to the MSXML2.XMLHTTP60 lib and do the calls
> yourself, far easier to use the lib.    Little bit of a learning curve to
> it, but once you've used it a time or two, it really simplifies a lot of
> things and most importantly, it has oAuth, which many sites are now
> starting
> to use.
>
>   Has lot's of good code, examples, and procedures that you can use.  It
> has
> a built-in JSON parser, can handle XML, and lots of helper functions to aid
> with calling API's. There are tutorials and YouTube video's on using it as
> well.
>
>  You'll like it (based on classes).   Great piece of work done by Tim.
>
> Jim.
>
>
> -----Original Message-----
> From: AccessD On Behalf Of John Colby
> Sent: Monday, March 13, 2023 1:30 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>; John Colby <jwcolby at gmail.com>
> Subject: [AccessD] Automating Google Maps
>
> Have any of you done any map automation?  I am looking to feed it addresses
> and have it bring up a browser (edge or google presumably) and map the
> address.  Get back turn by turn instructions.  Etc.
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting