This is the API tag.

API-tagged articles cover topics around web APIs, or Windows APIs, and how to use them in VBA.


Excel iconVBA icon

TimezoneDb API returns time zone information

TimezoneDb has an API which returns time zone information about a geographical point (latitude/longitude).

It requires an API key, which you can sign up for using the above link. I have an API key but have removed it for this example. In this article we'll review how to access the API using VBA. I've created a function which can be used on the worksheet (as a UDF) and also in VBA.

Continue Reading »

Peltier Tech Charting Utilities for Excel