The VBA Help blog

When getting information from the web (fetching a page, calling a REST endpoint, or reading a small text or JSON feed), the usual answer is MSXML2.XMLHTTP or WinHttp.WinHttpRequest, which means you are relying on the presence of the relevant library(s) on your (or an end-users) device. However, Windows already has an HTTP stack built in, WinINet, and a handful of its Functions will do a GET for you with no library required.

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.

VBE_Extras is now able to add 2,538 Windows API Functions (along with 601 Types, 99 Enums and 11,978 Consts) to your VBA code. In addition, VBE_Extras can add (or direct you to) example usages for 757 Windows API Functions.

Most of the procedures you write are called by you, or by VBA on your behalf. A callback turns that around: you hand another piece of software the address of one of your own procedures and let it do the calling. How to do this in VBA is with the AddressOf operator.

Getting extended file / folder attributes using the GetFileAttributesEx Windows API Function

The ":Zone.Identifier:$DATA" alternate data stream (ADS) ... unblocking files that have the "Mark of the web"

How to read, write and delete the alternate data streams (ADS) for a file or folder using VBA code?

How to get a list of the alternate data streams (ADS) for a file or folder using VBA code?

Expanding and unexpanding environment strings using the Windows API.

Working with the clipboard using the Windows API ... put text into the clipboard, get text from the clipboard, empty the clipboard, check whether the clipboard contents have changed.