Excel Insert Api Link Code May Work

This code may work with older version of Excel, but I have not tested it on versions earlier than 2016.

To do this, most of us open up Google Maps, or some other mapping tool, and find the coordinates that way.

Others use a latitudelongitude lookup tool such as latlong.net to find what they need.

While not overly time consuming, there is a more effective and accurate way to quickly grab a propertys coordinates without leaving Excel.

The service, made possible by the Google Maps Geocoding API, is commonly used online to quickly convert physical addresses to coordinates.

Ill show you how to incorporate these two options into your real estate modeling.

The API sets a limit on the number of requests you can make each second (50) and each day (2,500).

When you exceed the limit, you get a message that reads something like: Requestor has exceeded the server limit.

This may be exactly what you want since, if you share the workbook, other users of the workbook will have access to the custom function.

I learned how to do this after reading a post on the subject, written by Christos Samaras, on his engineering blog (of all places).

Ive recorded a video (see below) that walks you through the simple process of creating the function using Mr.

Samaras VBA code.

The video also explains how to get and insert your Google Geocoding API key.

One such Add-In Ive discussed here at Adventures in CRE is the WST Macros Add-In, which expands the world of keyboard shortcuts in Excel exponentially.

Add-Ins, when installed correctly, extend custom content to work across Excel files so that, for instance, a custom function like the Google Geocoding function can be used in every workbook you open.

Keep in mind, part of installing this add-in involves inserting your custom Google Geocoding API Key into the Add-ins VBA code.

Thus, its important to watch the video to ensure the Add-in is installed correctly.

Google offers the ability to increase the 2500 daily request usage limit, however youd need to get premiumpaid Google API key.

In newer versions of Excel, you may need to expressly Unblock the Add-in DuringAfter installing and whitelist the folder where the Add-in is located.

Ive included instructions under Option 2 for how to unblock the file.

To do this, Go to Tools - References - check the Microsoft XML, v3.0.

As of 2018, the code requires you to insert your own Google Maps Geocoding API key.

Excel Insert Api Link Free API Key

To get a free API key from Google, click here and then hit Get a Key.

There are a handful of reasons for these errors but generally these errors are because either the function wasnt setup correctly or the Google API key wasnt setup correctly.

My best advice if youre struggling with one of these error is to.

I know thats easier said than done, but if youre not saving the file as a Macro-Enabled file, not turning on Microsoft XML 3.0, entering the API key in the wrong place, inadvertently deleting something from the VBA code, or not entering the address correctly, etc, than you will get an error.

Excel Insert Api Link For Mac