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's gravatar image

James-Opes
11112
accept rate: 0%

1

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
Be the first one to answer this question!
toggle preview

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

Question tags:

×3
×36
×8
×3

question asked: 09 Oct '20, 16:39

question was seen: 668 times

last updated: 10 Oct '20, 09:08

powered by OSQA