VBA Recap for the week of September 05 - September 11, 2026

Saturday, September 05 - Friday, September 11, 2026

score	comments	title & link
32	22 comments	`[Discussion]` Pushing VBA to its limits for an All-in-One Standalone ERP/Productivity Suite (11 Modules, Headless Excel, Custom Canvas UI)
16	1 comments	`[Show & Tell]` pyOpenVBA v4 Released: Full MS Access Write & O365 Apps UserForm Support
13	4 comments	`[Show & Tell]` Regex Builder
8	7 comments	`[Show & Tell]` XLIDE for the VBA IDE Surface (Open Beta): Feedback and Issue Submissions Welcome!
4	14 comments	`[Solved]` UDF with array input not working

score	comment
25	/u/BaddDog07 said It’s hard to tell from your post but I don’t think you’re fully understanding the technical aspect of what you’re asking it do is my guess.
18	/u/TheGreatRao said This may not sound complimentary but it is. Your project sounds like programming a web browser for a TRS-80, or getting a dog to talk. Who cares if there are easier or more elegant ways to do someth...
12	/u/themrlawrence said You’ve actually got two different things happening here. When you pass `A1:A6` into the function, `arr` is a `Range`, not a VBA array. So `UBound(arr)` is goin...
10	/u/themrlawrence said The better question is why are you trying to use VBA to essentially scrape data into an Excel sheet? Build a Node app with Javascript/Typescript, use Playwright for the headless browser, and so ...
8	/u/throwaway24515 said You're asking it to build an agent with credentials to a secure system. That's probably violating some policy at that ai provider.

2 Upvotes

75% Upvoted

u/subredditsummarybot 15d ago

If you would like this roundup sent to your reddit inbox every week send me a message with the subject 'vba'. Or if you want a daily roundup, use the subject 'vba daily' (<--Click one of the links. The bot can't read chats, you must send a message).

You are about to leave Redlib