Using OSM in Excel to insert a street map

In Excel VBA and using the Google Maps API I can insert a Google Map into a square shape in my workbook using the “Sheet1.Shapes("DisplayMap").Fill.UserPicture” function. I’d like to do the same using OSM but I cannot seem to find any examples where anyone has done something similar.

I’d like to know where I can find information about the options I can use un the URL to manage the size of the returned map, the zoom level and whether to display or hide and points of interest. If there are also any stylizing options regarding the colors used for modeling roads, parks, etc. I’d like to know how to control that too.

This is what the Google Maps API URL would look like. What would a similarly capable OSM URL look like?

GoogleURL = “https://maps.googleapis.com/maps/api/staticmap?center=Champ+de+Mars+5+Avenue+Paris+France,0&markers=|Champ+de+Mars+5+Avenue+Paris+France|&zoom=15&size=1280x1280& style=feature:poi|visibility:off&MapType=Satellite&scale=4&key=API_KEY”

asked 09 Oct '20, 16:39

James-Opes
11●1●1●2
accept rate: 0%

I think a screen snip/grab should work

(10 Oct '20, 09:05) andy mackey

or maybe cut and paste. I don't have Excel any longer so can't be sure.

(10 Oct '20, 09:08) andy mackey

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

osm ×710
api ×290
url ×39
excel ×9
vba ×3

question asked: 09 Oct '20, 16:39

question was seen: 2,710 times

last updated: 10 Oct '20, 09:08

Using OSM in Excel to insert a street map

Follow this question

Related questions