The VBA Help blog

When using VBE_Extras, you can right-click on a Project name in the VBE's Project window and choose to load an entire Project's worth of Modules at once from a set of files ... or you can save all of the Modules in a Project at once.

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.

Most VBA developers only ever consume events like Worksheet_Change. But you can declare and raise your own. This post builds a small worker Class that raises events and a listener that handles them ... without the Class knowing who's listening.

Looking for VBA developers who are willing to carry out some testing of VBE_Extras when the VBE is hosted in Autodesk Inventor and / or Autodesk AutoCAD.

mscomct2.ocx contains the Animation, Date and Time Picker (DTPicker), FlatScrollBar, MonthView and UpDown Controls. This post describes how to download and install mscomct2.ocx, and how to add the Controls to the Toolbox and a UserForm.

Sometimes you don't know until run time which method to call ... the name's sitting in a cell, a file, a registry key or a button's Tag. VBA's CallByName turns that String into a call: getting or setting a property, or calling a method, by name.

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.

VBE_Extras now has a Code Explorer dialog which allows you to explore the entire code base loaded into the VBE.

VBE_Extras is now available to all users in the VBE when hosted by Microsoft Visio and Microsoft Project.