top of page
Profile
Join date: Oct 15, 2020
Posts (148)
Jul 14, 2026 ∙ 7 min
Adding AI generated UserForms to your VBA Project (using .frxml files)
A frustration that I have with using AI to support me in writing VBA code is generating UserForms ... specifically the UI part of UserForms. Here's a solution using an AI skill, a .frxml file and VBE_Extras.
106
0
1
Jul 13, 2026 ∙ 2 min
Syncing a VBA Project with a file(s) ... manually
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.
46
0
Jul 10, 2026 ∙ 4 min
Make an HTTP(S) GET request and read the response using the Windows API
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.
174
0
John
Admin
More actions
bottom of page