Open a map

[Mahall906]

Learning newbie here..... still

I have a text box called 'address'. In it goes the full UK address of an individual.

I know I can create a button to open a web browser to show Google Maps, however; how can I get that OnClick button to open a map based on the address details in the 'Address' text box?

I have tried a few codes but they seem to be a tad dated.

Any help would be appreciated!

 

[Minty]

I think this page will give you what you need;

Get Started | Maps URLs | Google for Developers

Maps URLs provide a universal URL scheme to launch Google Maps from any platform.

developers.google.com

 

[isladogs]

I have several apps that do exactly that for UK addresses. Some are commercial apps, others are free.
This is a link to a free ACCDE example app UK Postcode Address Lookup - Mendip Data Systems (source code is available at a low cost).
Or look at the code behind this free ACCDB example app Get Geolocation From Photos - Mendip Data Systems

You will need to obtain an API key from Google to use their static mapping API. That's also free unless you download over about 20000 maps per month. The documentation is at Get Started | Maps Static API | Google Developers and its very clear and detailed.

 

[plog]

You just need to construct the url correctly with the address and use Shell.Application:

Sub test()

str_Address="10+Downing+St,+London+SW1A+2AB,+UK"

CreateObject("Shell.Application").Open "https://www.google.com/maps/place/" & str_Address


End Sub

 

[Mahall906]

Thank you all for your help. Sorted and works a treat!

 

[isladogs]

Excellent. Which method did you use?

 

[Mahall906]

Found this example and changed it accordingly. It was primarily one for a postcode entry but it works a treat.

 

[isladogs]

I may be wrong but I think that looks like some of my code. Anyway, glad you have a solution.