One of the things I think is amazing about VBA is the fact that it is so incomplete in some ways. For instance, did you know that there is no native way to get the local timezone offset. Yesterday I was working on a VBA SOAP plugin for Excel and realized this horrible fact. Of course, my first instinct was to Google the answer. Unfortunately, not even Google could provide a satisfactory (meaning short) solution. Therefore, I came up with the following VBA function:
Public Function GetTimezoneOffset() As Integer
Dim ie As New InternetExplorer
ie.Visible = False
While ie.readyState <> READYSTATE_COMPLETE And Not ie.Busy
ie.Document.parentWindow.execScript "n = (new Date).getTimezoneOffset()"
GetTimezoneOffset = ie.Document.parentWindow.n
var offset = (new Date).getTimezoneOffset();