Excel
The Excel category is all things Excel. Functions, formulas and macros are all covered in this category. If it happens in Excel, you will find it in this category.
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 »
Sending Emails from Outlook using VBA in Excel
In case you didn't already know, I always enjoy reading articles about interop between Outlook and Excel using VBA code. So I read the recent guest post on Chandoo's site with interest. I downloaded the sample workbook to study the code, and I suggest you do the same.
Continue Reading »
Follow Me