top of page
The VBA Help blog
Search
Get the current time zone, UTC offset and daylight saving state
VBA can tell you the current date and time, but not which time zone you're in, how far that is from UTC, or whether daylight saving is in effect right now. Windows knows all three, and a single call of the GetDynamicTimeZoneInformation Windows API function gets them for you.
Jun 223 min read
Â
Â


Pause processing
Code often needs to pause and wait for something else to happen. There are a number of options to do this. In Excel, you can use...
Feb 22, 20222 min read
Â
Â


Get the local date and time including milliseconds
This code uses the GetLocalTime Windows API to get a more accurate time than VBA will supply, accurate to around 15 milliseconds. You can...
Feb 22, 20221 min read
Â
Â


Articles: Blog2
bottom of page