Google Maps picture into word document

[crxftw]

Hello, I was wondering if it's any way possible to capture image of google maps somehow (based on link or address) and have the image pasted into my word document via vba that's also generated inside the database which fills couple of fields on word template file and saves it to specific folder.

Thanks.

 

[spikepl]

Before you attempt that check the terms of service or copyright. As far as I recall you cannot just do what you want without some licensing.

 

[crxftw]

Well I am pretty certain that if there are tons of custom api-s made my users then this shouldn't be copyrighted in any way. It would basically fall into the same category to have 5 address fields in your form and on button click open browser that points to that address.

My reason for that though is simple. I print out client forms for employees with instructions and would like to have map to their house on 2nd page of the document. So instead making document with button click and then go to google maps, print screen, paste it to word and format it, I'd love do to it all in one. Just to have the image there if possible, maybe it's beyond vba anyway, but would like to hear if there's any possibility for that to make it happen. The formatting part isn't an issue, it's just to have the image on the word doc.

Also found api to access static image url-s:

https://developers.google.com/maps/documentation/imageapis/

 

[spikepl]

Which part of "check the terms of service or copyright" was unclear?

Honestly, make the effort and find out, especially since it has been pointed out to you that it might be an issue. "Pretty certain" doesn't cut it anywhere.

 

[crxftw]

I am asking for actual solution, not permission if I can do it or not, which I obviously can find out myself and I know that I am allowed to do it.

 

[spikepl]

Find another partner in crime then.

 

[crxftw]

That has been very helpful of you. Trying to work out a code with free google maps api is gonna get you in world of trouble.

 

[spikepl]

All it would take for you is to check the terms and conditions, and quote them here.

If you cannot accomplish that task "Becaue I know that I am right", then you have no business in writing apps for other people.

Technically, you can easily rip info of any web page, API or no API. But that's why quite often the TOS disallow that, because even the "free" services still want to make a living.

 

[crxftw]

I understood. You have no intention to be part of it.

I've already acknowledged myself that using a static image the way I'd have it done, provided by google maps api, is what I am allowed freely to do with no restrictions that would violate any part of the ToS.

 

[crxftw]

Found perfect module from the forums if anyone bothers to check that out:

http://www.access-programmers.co.uk/forums/showpost.php?p=1050182&postcount=4

My idea would be have a rooftop view image copied and pasted over to word document.

 

[NigelShaw]

Found perfect module from the forums if anyone bothers to check that out:

http://www.access-programmers.co.uk/forums/showpost.php?p=1050182&postcount=4

My idea would be have a rooftop view image copied and pasted over to word document.

Hi
The db in the link doesn't actually give you the image to paste though does it.


Nidge

 

[jdraw]

I agree Nidge, I think it gives you a link that you can include in html.

From Google:

All we needed to do was create a URL, and place it within an <img> tag. You can place a Google static map anywhere on your webpage where you can place an image.