I'd like to have excel create a link to a fixed google map based on text from another cell. Here's a link I found to provide a static google map of any location:
http://maps.google.com/maps/api/stat...p&sensor=false
That link will produce a static map of Boston, MA. But I can't get Excel to fill that small portion of the link that specifies location with whatever I type in a different cell.
Example: In cell A1, I have "Boston, MA". In cell A2, I would like to have excel replace a portion of a fixed link with the text from A1.
http://maps.google.com/maps/api/staticmap?center=THIS PART HERE SHOULD FILL WITH THE ADDRESS FROM CELL A1&zoom=15&size=512x512&maptype=roadmap&sensor=false
But whenever I type:
=HYPERLINK("http://maps.google.com/maps/api/staticmap?center=A1&zoom=15&size=512x512&maptype=roadmap&sensor=false";"map"),
The map produced actually uses the text A1, rather than the text from the cell A1.
How do I get it to populate the text from the cell into that portion of the link?
Thanks!
Bookmarks