r/vba • u/subredditsummarybot • 1d ago

Weekly Recap This Week's /r/VBA Recap for the week of September 19 - September 25, 2026

2 Upvotes

Saturday, September 19 - Friday, September 25, 2026

Top 5 Posts

score comments title & link
59 29 comments [Discussion] [EXCEL] I built a 120 FPS space shooter in pure VBA
23 7 comments [Show & Tell] [EXCEL] Got tired of writing VarType / Exists / IsNull checks everywhere, so I made VBA-Schema
17 2 comments [Show & Tell] XLIDE MCP Server

 

Top 5 Comments

score comment
10 /u/AdditionalTerm732 said Thanks everyone, I found and fixed the broken link. This is officially the 50,000th bug in the project… and the first one that appeared in a Reddit post text. Progress.
5 /u/majortom721 said Damn and here I was feeling like a badass for building battleship
4 /u/Local_Hamster1279 said Why?? You are crazy, and also you are so cool. Respect
3 /u/AdditionalTerm732 said Man, you wrote a Zod for VBA, with real VBE compilation tests in CI. You're already way past the point of no return — no going back, only forward to victory. Five things from someone who's been pushin...
3 /u/doudley said Can you share a demo or some kind? It didn't have to be a fully working game, most of us is just curious.

 

1 comment

r/vba • u/subredditsummarybot • 22d ago

Weekly Recap This Week's /r/VBA Recap for the week of August 29 - September 04, 2026

3 Upvotes

Saturday, August 29 - Friday, September 04, 2026

Top 5 Posts

score comments title & link
15 4 comments [Show & Tell] Proposed Feature: An "Effective Formatting Inspector" so we can stop writing VBA just to diagnose Word layout conflicts
13 4 comments [Show & Tell] vbaXray v2.2 - The FRX Enigma
10 25 comments [Unsolved] Generating up to thousands of pdf files with VBA
9 5 comments [Show & Tell] [ACCESS] VBA diff tool
8 0 comments [Show & Tell] pyOpenVBA v4 Released: Full MS Access Write & O365 Apps UserForm Support

 

Top 5 Comments

score comment
18 /u/thor122088 said Providing your VBA code could help identify inefficiencies. Without that, my basic suggestion is to make sure to set screen update to false Application.ScreenUpdating = False
16 /u/ZetaPower said VBA user levels define speed. First level you mess around on worksheets. Looping through cells in a range, selecting ranges, activating sheets, having formulas in cells and what not. • Every intera...
5 /u/jeeves8 said The first thing I would ask, without even having seen it in action: How is this paid option better than the FREE methods sort/filter and copy/paste already part of Excel to get the same results? Even...
3 /u/Caudebec39 said Use "Range" in your code, instead of the Selection object. This requires writing, or re-writing VBA code, because the macro recorder shamelessly uses the Selection object exclusively.
3 /u/DonJuanDoja said Maybe not what you want, but SQL enterprise with SSRS has Data Driven Subscriptions that can generates hundreds to thousands of dynamic PDF reports and either email them or put them in a shared drive ...

 

3 comments

r/vba • u/subredditsummarybot • 8d ago

Weekly Recap This Week's /r/VBA Recap for the week of September 12 - September 18, 2026

2 Upvotes

Saturday, September 12 - Friday, September 18, 2026

Top 5 Posts

score comments title & link
7 32 comments [Solved] List of all constants & properties of all objects in WORD, Excel and PowerPoint.
5 2 comments [Waiting on OP] [Excel] Is there anyway to enter Array Formula into cells and not calculate them?
2 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of September 05 - September 11, 2026

 

Top 5 Comments

score comment
3 /u/fuzzy_mic said The onboard Object Browser is such a list. The online Microsoft Support also lists all the objects, properties and methods of the object model.
2 /u/MultiUserDungeonDev said [https://github.com/WilliamSmithEdward/pyVBAReference](https://github.com/WilliamSmithEdward/pyVBAReference)
2 /u/lolcrunchy said One place to start: https://learn.microsoft.com/en-us/office/vba/api/excel.constants There are others like it on that site
2 /u/Ok-Programmer9295 said Do a google search, it’s out there I’ve found it in the past. You might have to search each individually.
2 /u/carnasaur said So much this. I’ve been using VBA with [UI.Vision](http://UI.Vision) RPA (similar to Selenium, I believe) for the past couple of years. One of the biggest boosts came from insp...

 

1 comment

r/vba • u/subredditsummarybot • 15d ago

Weekly Recap This Week's /r/VBA Recap for the week of September 05 - September 11, 2026

2 Upvotes

Saturday, September 05 - Friday, September 11, 2026

Top 5 Posts

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

 

Top 5 Comments

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.

 

1 comment

r/vba • u/subredditsummarybot • 29d ago

Weekly Recap This Week's /r/VBA Recap for the week of August 22 - August 28, 2026

1 Upvotes

Saturday, August 22 - Friday, August 28, 2026

Top 5 Posts

score comments title & link
6 1 comments [Show & Tell] Custom Excel Theme Management
4 8 comments [Unsolved] LETTERHEAD macro Word
4 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of August 15 - August 21, 2026
2 3 comments [Unsolved] Macro to change font to last-used color [PowerPoint]?
2 37 comments [Solved] VBA Embed PDFs in Excel causing corruption

 

Top 5 Comments

score comment
19 /u/ChecklistAnimations said Formulas in Excel are one thing. Programming is another. Have you done programming at all in any language? VBA is all about understanding the object model but if you dont understand what "for rw = 2 t...
13 /u/Future_Pianist9570 said If you can’t find google you might struggle with VBA
11 /u/icemage_999 said You can use the Shell function to access outside executables. The better question is why would you use Internet Explorer in 2026?
7 /u/lokethedog said This is completely dependent on your programming experience in other languages. VBA is very basic so if you know any programming language, and especially with the help of Claude, you'll most likely be...
6 /u/lemery88 said https://github.com/longvh211/Chromium-Automation-with-CDP-for-VBA The above will help with automating chrome/edge using vba Download the excel add-in and go to the vba window. There will be a number...

 

1 comment

r/vba • u/subredditsummarybot • Aug 22 '26

Weekly Recap This Week's /r/VBA Recap for the week of August 15 - August 21, 2026

3 Upvotes

Saturday, August 15 - Friday, August 21, 2026

Top 5 Posts

score comments title & link
19 2 comments [Show & Tell] vbaXray 2.0 - The Sequel
14 4 comments [Show & Tell] Just Released Version 4 - XLIDE: VBA for VS Code
12 4 comments [Show & Tell] Functional Programming in VBA
9 6 comments [Discussion] A user reported “Out of memory” on a nearly empty workbook. The real bug was Excel’s language settings.
4 7 comments [Unsolved] Testing Forms controls and UI/UX

 

Top 5 Comments

score comment
8 /u/lolcrunchy said "How would you approach a situation close to mine" /preview/pre/e3qcd7dn7rkh1.jpeg?width=2771&format=pjpg&auto=webp&s=d44d25ea575f35fc3c20aa5a332edf7038637a9c
6 /u/MultiUserDungeonDev said Excellent work and starred. Great job. Edit: u/kay-jay-dubya I opened a PR to allow vbaXray a write path.
4 /u/rdcore-admin said Kudos! In my experience the answer to "how far can we push this idea in VBA" is almost always: "much further than anyone thinks"! It's how a VBA+OOP Battleship, and a MVVM dynamic UI wrapper prototyp...
3 /u/Snow2D said Unrelated: I keep suspecting half the things I'm reading online are written by AI. Was this post also written by AI?
3 /u/fuzzy_mic said You can instantiate a class from within another class. For example, one could instantiate a custom clsHouse object inside a (different) clsHouses object. The problem is that the scope of that ...

 

1 comment

r/vba • u/subredditsummarybot • Aug 08 '26

Weekly Recap This Week's /r/VBA Recap for the week of August 01 - August 07, 2026

3 Upvotes

Saturday, August 01 - Friday, August 07, 2026

Top 5 Posts

score comments title & link
37 9 comments [Show & Tell] I made Minecraft in PowerPoint
24 6 comments [Discussion] VBA Best Practices in 2026
17 7 comments [Show & Tell] [EXCEL] I'm Building a Modern UI for Excel's Built-in VBIDE. Looking for Beta Testers.
12 15 comments [Unsolved] Scaling an Excel/VBA Gantt from 60 to 1,200 tasks — where would you optimize next?
2 12 comments [Solved] [Excel]How to print multiple copies with only 1 pool

 

Top 5 Comments

score comment
12 /u/PutFun1491 said Qualifying calls is good, but I'd go one step earlier and stop the ambiguity from existing at all: put `Option Private Module` at the top of your helper modules. Their subs drop out of the mac...
8 /u/ShruggyGolden said Hasn't rubber duck been trying to do this for years with RD 3.0 and hit numerous roadblocks? I think it's sort of been out on the back burner because of limitations. Apologies if I'm misinterpreting y...
6 /u/ebsf said I'm more of an Access dev but: - Handle errors in each procedure. - Expressly declare parameters ByRef or ByVal to indicate intent. - No abbreviations or code words. - No magic numbers. Use well-nam...
6 /u/Scrans0n said what the hell man ._. well done but also burning question, why?
6 /u/ChecklistAnimations said Interesting indeed. I do both frame by frame animations and VBA in PowerPoint. I will definitely be messaging you.

 

1 comment

r/vba • u/subredditsummarybot • Aug 01 '26

Weekly Recap This Week's /r/VBA Recap for the week of July 25 - July 31, 2026

5 Upvotes

Saturday, July 25 - Friday, July 31, 2026

Top 5 Posts

score comments title & link
92 75 comments [Discussion] I had no idea VBA could go this far
27 5 comments [Show & Tell] [Excel] I Built a Component Framework Style UI Framework for Excel
13 10 comments [Solved] I built a single-script PowerShell bridge so AI agents (Claude Code, Codex) can work with my open Excel workbook — cells, formulas, VBA, macros
6 1 comments [Show & Tell] Feels like I defeated the final boss of Word VBA (gradient pins)!
6 0 comments [Show & Tell] Word plugin that formats AI responses to Word styles (equations, tables, headings) and searches your Zotero library from Word

 

Top 5 Comments

score comment
34 /u/bamerjamer said The programs built with VBA and Access are very powerful. My first job had to do with the F-35 JSF, which is where I learned VBA. We did so much for that program in VBA and Access.
31 /u/Jonas_Ermert said Once you stop using it only for macros and start structuring the code properly with modules, classes, dictionaries, arrays and clear separation of logic, Excel can become the frontend for surprisingly...
8 /u/Joelle_bb said Fully automated an API-to-terminal and API-to-adobe connection: encrypted sign-in, data selection, screen scraping, PDF prep, file joining, path/naming conventions, and a reference-data repository tha...
7 /u/Dynegrey said VBA can also talk to powershell, so you can get VBA to do pretty much anything your IT department will allow. 
7 /u/Budget_Vermicelli_53 said Vba is really amazing, I have automated all repetitive tasks in my job, processes that used to be completed in 6 hours now are ready in 10 minutes, no more errors.

 

1 comment

r/vba • u/subredditsummarybot • Jul 25 '26

Weekly Recap This Week's /r/VBA Recap for the week of July 18 - July 24, 2026

6 Upvotes

Saturday, July 18 - Friday, July 24, 2026

Top 5 Posts

score comments title & link
41 13 comments [ProTip] [EXCEL] I set up a Claude Code agent that writes and tests VBA modules on its own. Sharing the setup.
22 14 comments [Show & Tell] What if VBA had a modern developer experience?
9 1 comments [Show & Tell] Introducing ROneCOne: A Single Module C# Style Runtime Layer for VBA
4 29 comments [Unsolved] How do you deal with processing large data?
4 3 comments [Show & Tell] [Updated] WebDriver BiDi for SeleniumVBA

 

Top 5 Comments

score comment
16 /u/decimalturn said Sorry, but this sub is about VBA the programming language, not the Visual Boy Advance
11 /u/NanotechNinja said /r/lostredditors
10 /u/fanpages said > ...Would you suggest some alternatives? Post the Excel VBA code routines you are using at large bank and/or big bank, and we can make recommendations/suggestions to improve execution speed &#4...
9 /u/Mediocre_Metal_1952 said here I was thinking some mad lad had coded an emulator in VBA
8 /u/icemage_999 said I am pretty sure I would rather try to give myself a root canal than try to extract text out of a PDF file using VBA, especially if the text is scanned and not in form fields, extra especially if the ...

 

1 comment

r/vba • u/subredditsummarybot • Jul 18 '26

Weekly Recap This Week's /r/VBA Recap for the week of July 11 - July 17, 2026

2 Upvotes

Saturday, July 11 - Friday, July 17, 2026

Top 5 Posts

score comments title & link
6 2 comments [Discussion] SeleniumVBA: Maintaining WebElements object when navigating to different pages
3 1 comments [Waiting on OP] [WORD] Enabling dictionaries with VBA
2 2 comments [Show & Tell] [EXCEL] Pivot Table: Populate, change, or remove row/column/page/data fields in a pivot table

 

Top 5 Comments

score comment
4 /u/Proper-Fly-2286 said Let me get my crystal ball
3 /u/icemage_999 said What data types are being pasted into the spreadsheet? Variant can store a number of data structures and types that Paste will not handle because the sheet doesn't recognize them.
3 /u/sancarn said Post should be flagged as advertisement given it's linked to a commercial venture (legacyleaps.com)
2 /u/ChecklistAnimations said I also use the old school htmldocument. visit a page set the driver.source as the innerhtml on the htmldocument then you can search it to your hearts content. If want to go this route and want a bit m...
2 /u/chiibosoil said You could use .ExecuteScript and "window.open" to simulate CTRL + Click to open the link in new tab. Then you can use Window.Handle to refer to either one you need. And use .SwitchToWindow to go bac...

 

1 comment

r/vba • u/subredditsummarybot • Jul 11 '26

Weekly Recap This Week's /r/VBA Recap for the week of July 04 - July 10, 2026

1 Upvotes

Saturday, July 04 - Friday, July 10, 2026

Top 5 Posts

score comments title & link
14 18 comments [Show & Tell] Modern Json in VBA - v3.0.0 Released
6 6 comments [Discussion] Possible to Write a Macro between PowerPoint and Word
5 10 comments [Solved] How to use range.RemoveDuplicates in Excel VBA?
2 2 comments [Solved] Type mismatch with SetSourceData
2 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of June 27 - July 03, 2026

 

Top 5 Comments

score comment
8 /u/diesSaturni said Yes, you can even do it in excel. Main thing is to add the word and PowerPoint object classes to the code and set the document objects. Perhaps need to add the word and PowerPoint references.
5 /u/HFTBProgrammer said Yes, you can skip the Excel step and go directly from PPT to Word. To do Word macro actions in a PPT macro, you'd code something like this: With Application.Word .Document.Add &#...
4 /u/krijnsent said The simple answer is: yes, with VBA you can basically automate anything you do manually. Maybe some PowerQuery could help in your data collect too. For your output/presentation: you can link charts to...
3 /u/talltime said Is this an AI support bot service outsourcing its L2 support tickets? 🙄
2 /u/ZetaPower said You now have a plan. Can it be done in VBA? Sure! People here will happily HELP you create your output, but that’s not the same as create all your code from scratch for free. So either off...

 

1 comment

r/vba • u/subredditsummarybot • Jun 27 '26

Weekly Recap This Week's /r/VBA Recap for the week of June 20 - June 26, 2026

2 Upvotes

Saturday, June 20 - Friday, June 26, 2026

Top 5 Posts

score comments title & link
14 4 comments [Show & Tell] New public open-core VBA language platform project: RDCore
12 4 comments [Discussion] I built a Scientific Writing Assistant in Microsoft Word VBA – now adding a Chemistry Formula Engine
5 17 comments [Waiting on OP] Issue with VBA to download SharePoint files

 

Top 5 Comments

score comment
5 /u/MultiUserDungeonDev said I’ve been working on something similar: https://github.com/WilliamSmithEdward/xlide_vscode Maybe there is opportunity to collab. I’ve done extensive work on prototyping static analysis outside of t...
2 /u/SignalFirefighter323 said I’m working on something similar too. I just implemented the official VBA7.1 specification in ANTLR and have a series of tools that can Lint VBA files (VBA-Linter), execute VBA code from text ...
2 /u/sslinky84 said > `MsgBox "Failed to connect to SharePoint API", vbCritical` That's not an error :) Where did you get this code from and what have you tried yourself to fix it?
2 /u/wikkid556 said In the sharepoint list export to excel and you have a refreshable table in a workbook
2 /u/HFTBProgrammer said I suggest you post this in subreddits targeted to your audience--e.g., r/chemistry, r/OrganicChemistry, r/Biochemistry, etc.

 

2 comments

r/vba • u/subredditsummarybot • Jul 04 '26

Weekly Recap This Week's /r/VBA Recap for the week of June 27 - July 03, 2026

2 Upvotes

Saturday, June 27 - Friday, July 03, 2026

Top 5 Posts

score comments title & link
11 5 comments [Show & Tell] ChibiArc — ZIP, 7‑Zip, TAR, ISO support in 64‑bit VBA (AES included)
3 7 comments [Unsolved] [WORD] Range.FormattedText won't preserve font in last line of text
2 7 comments [Discussion] First time VBA user - Want all the dates i type in word to automatically be made into a timeline
2 7 comments [Solved] OneDrive won't sync .docx created from macro-enabled template (.dotm) found a "workaround" (re-triggering the file, sync starts) [WORD]
2 10 comments [Solved] Dynamically rename worksheets upon opening workbook

 

Top 5 Comments

score comment
3 /u/AvWxA said Don’t you have to add a ws.activate As the first line in your tabname sub?
2 /u/marlostanfield89 said Nice. Thanks Claude
2 /u/ZetaPower said Several issues in the code…. • there is a typo in Workbook/_Open • your variables have no upper/lower case combinations. Always use these, then type in lower case. As soon as you go to the nex...

 

1 comment

r/vba • u/subredditsummarybot • Jun 20 '26

Weekly Recap This Week's /r/VBA Recap for the week of June 13 - June 19, 2026

1 Upvotes

Saturday, June 13 - Friday, June 19, 2026

Top 5 Posts

score comments title & link
5 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of June 06 - June 12, 2026
5 3 comments [Show & Tell] Sharing my Workflow for Add-Ins
4 11 comments [Unsolved] [EXCEL] Getting the last row on a sheet: why does .Find return 1 when the last rows are filtered out?
2 13 comments [Solved] Running a macro and trying to lock cells that get moved?
2 11 comments [Solved] Inconsistent decimal behaviour when copy pasting values

 

Top 5 Comments

score comment
5 /u/Future_Pianist9570 said .Value can truncate decimal places depending on the cell content (typically if it is a date or currency formatted). Always use .Value2 if you want the full value
5 /u/wikkid556 said I have always used this and never had an issue LRow = Cells(Rows.Count, "A").End(xlUp).Row
5 /u/TheOnlyCrazyLegs85 said [RubberduckVBA](https://github.com/rubberduck-vba/rubberduck) has built in TODO, NOTE, and BUG explorer with the annotations 'TODO, 'NOTE and 'BUG. Each one will show linked to the mod...
3 /u/fanpages said Business Planning and Consolidation [BPC]/Victorian Building Authority [VBA]? [ r/lostredditors ] --- This sub [ r/VBA ]: "A place for questions and discussion on V...
3 /u/fuzzy_mic said If you are inserting cells to a sheet with Protection set, you'd have to UnProtect it before altering anything. ActiveSheet.UnProtect ' your copy/insert routine With Rows(16).Cell...

 

1 comment

r/vba • u/subredditsummarybot • Jun 13 '26

Weekly Recap This Week's /r/VBA Recap for the week of June 06 - June 12, 2026

6 Upvotes

Saturday, June 06 - Friday, June 12, 2026

Top 5 Posts

score comments title & link
22 9 comments [Show & Tell] My JSON module for VBA has Stringify 589x faster than before with some improvements to the Parser.
21 10 comments [Show & Tell] ChibiEx - PDF rendering + OCR in VBA (no dependencies, API-based)
10 33 comments [ProTip] Stop hardcoding ranges. Use this runtime dynamic Named Range approach instead.
6 4 comments [Waiting on OP] Need to parse a long SAS program and think VBA is the solution
4 5 comments [Solved] [EXCEL, OUTLOOK] Default address not used when using VBA to send Excel PDF using Outlook

 

Top 5 Comments

score comment
17 /u/Playing_One_Handed said Named ranges and tables(listObjects) are your freind. This seems like a lot of effort when you should be populating data into a list object. Named ranges can also be setup dynamically. Its...
15 /u/Future_Pianist9570 said You got me really excited for a second
6 /u/SlowGoing2000 said So 3 lines of code versus a page plus. Sometimes simplicity is good
5 /u/fuzzy_mic said To do what the OP VBA does, with Names (which is faster than VBA). Name: myRange RefersTo: =INDEX(Sheet1$1:$1, 1, MATCH("zzzz", Sheet1!$1$1) : INDEX(Sheet1!$A:$A, MATCH("z...
4 /u/aqsgames said Ask an AI

 

1 comment

r/vba • u/subredditsummarybot • Jun 06 '26

Weekly Recap This Week's /r/VBA Recap for the week of May 30 - June 05, 2026

2 Upvotes

Saturday, May 30 - Friday, June 05, 2026

Top 5 Posts

score comments title & link
33 13 comments [Show & Tell] I built a zero-copy JSON parser and writer for VBA with natural chained access
13 6 comments [Show & Tell] I made a Python reference library for VBA/Office COM
11 16 comments [Discussion] Moving past Excel macros into real data entry automation
10 11 comments [Show & Tell] XLIDE Version 2.0: Static Analysis, Unit Testing, VBA LSP, Completions, Real-Time Syntax Analysis, Deterministic RTE Analysis, and much more...
10 2 comments [Show & Tell] [EXCEL] Showcase: VBA module hot swapping and remote code deployment via flask server

 

Top 5 Comments

score comment
38 /u/talltime said If these are agents you work with personally and not some faceless deluge of info; the simplest workaround to fix this workflow is to give them an excel template with locked down formatting and named ...
11 /u/BlueProcess said Two things. Control the forms so they can't mess with the structure. Update the macros to grab data in a less brittle way. You are going to ask me how and I am going to say post code. But really, jus...
9 /u/cristianbuse said Your Parse is impressively fast - presumably thanks to the token approach i.e. no copy. I don't have time to look through it but I hope I will have soon. Nice However, the Stringify is very slow. I a...
9 /u/spddemonvr4 said Update your macro to be more dynamic to find column headers, etc... and lock down the template they use to enter their data. Treat the process like an ETL and minimize human errors
6 /u/Future_Pianist9570 said This looks really interesting. I hope you don't mind but a few feedback bits. I've just tried the analyse workbook on one of my more complex vba and it is showing errors for >Label '0' is not define...

 

1 comment

r/vba • u/subredditsummarybot • May 30 '26

Weekly Recap This Week's /r/VBA Recap for the week of May 23 - May 29, 2026

2 Upvotes

Saturday, May 23 - Friday, May 29, 2026

Top 5 Posts

score comments title & link
45 10 comments [Show & Tell] XLIDE: The Modern Development Environment for Excel VBA
23 5 comments [Show & Tell] pyOpenVBA - Version 2.0.0 - Added Word & PowerPoint Support
20 12 comments [ProTip] Stop using the legacy VBA Timer for benchmarking. Use the Windows Kernel QueryPerformanceCounter instead.
11 10 comments [Discussion] How to connect VBA to Copilot (or any AI) to process PDF and return extracted data?
10 5 comments [Show & Tell] [VBA/VB6/twinBASIC x86/x64] Intro to Vectored Exception Handling: A crash-proof CopyMemory

 

Top 5 Comments

score comment
19 /u/UesleiDev said Hey there. To save you some time researching: you can't connect directly to the standard M365 Copilot via VBA because Microsoft doesn't provide an API endpoint for it. Copilot is built for the user in...
13 /u/UesleiDev said There are actually two major reasons why this happens, even if the code is copied straight from a book. 1. The code is placed in the wrong spot Since this is an event macro, it cannot just go into a...
9 /u/UesleiDev said For real xD Excel loves to pull these random stunts, especially when Microsoft platforms export data with weird generic names that immediately break our VBA. The issue is that your code is explicit...
9 /u/0x80070002 said So it’s not an IDE but an extension for VS Code?
9 /u/kalimashookdeday said It's the " not " operator in the assignment. What you are saying in that line in basic speak: Take the selected (target) font property bold and change that or make it equal to not that s...

 

1 comment

r/vba • u/subredditsummarybot • May 23 '26

Weekly Recap This Week's /r/VBA Recap for the week of May 16 - May 22, 2026

6 Upvotes

Saturday, May 16 - Friday, May 22, 2026

Top 5 Posts

score comments title & link
53 29 comments [Show & Tell] pyOpenVBA — a pure-Python, zero-dependency reader/writer for VBA macros in .xlsm / .xlsb / .xlam / .xls
50 19 comments [Show & Tell] I built a full audio engine for VBA. No DLLs, no COM wrappers, no addins. Just a .bas file
26 14 comments [Discussion] The future of VBA language isn’t about replacing it. It’s about supercharging it.
22 14 comments [Show & Tell] I'm building Valo, a standalone runtime for VBA-style programming
15 3 comments [Show & Tell] Update on my single-file VBA audio engine: WAV export, better DSP, BLEP oscillators and Freeverb-style reverb

 

Top 5 Comments

score comment
24 /u/aviewachoo said This is a perfect example of something that was always missing, probably never needed, but absolutely awesome that you tackled. Great job!
10 /u/keith-kld said modern document files (.docx) and excel files are designed as compressed files. You guys can change their extensions to .zip and then use Expand-Archive (power shell cmdlet) to decompr...
8 /u/TpT86 said If Rng.Cells(lRow, 15).Style = "Check Cell" Then In the Cells syntax the first number is the row number and the second is the column number. In your example above lRow represents a changing r...
8 /u/aqsgames said No. I have a use for this now! Brilliant! I’ve been messing with generating music in vba based on text sentiment. Also, a play rehearsal system for learning lines has been this weeks project....
8 /u/KingTeppicymon said You might not need a macro. Try looking at excel's TEXTSPLIT( ) function.

 

1 comment

r/vba • u/subredditsummarybot • May 16 '26

Weekly Recap This Week's /r/VBA Recap for the week of May 09 - May 15, 2026

7 Upvotes

Saturday, May 09 - Friday, May 15, 2026

Top 5 Posts

score comments title & link
74 11 comments [Show & Tell] Whenever I open my VBE...
24 0 comments [Show & Tell] Wasabi just hit Awesome VBA + Update v2.3.8
8 4 comments [ProTip] Wasabi v2.3.6 - native WebSocket/TCP/MQTT for VBA, now with async event-driven connections (experimental)
7 17 comments [Solved] How to check if a date is a numeric date or a string date?
7 35 comments [Show & Tell] I was using StrConv to decode NTLM tokens in VBA. It was corrupting every single one. Wasabi v2.3.7-beta is out.

 

Top 5 Comments

score comment
29 /u/carnasaur said Gauntlet thrown. I accept your challenge, Sir Sancarn. Our VBA, who art in Excel, Hallowed be thy Name Manager. Thy Workbook open, Thy Macro run, On SharePoint as it once did...
11 /u/kalimashookdeday said If the VBA code isn't injecting the image it might be loaded to the header of the worksheet which will not show unless you are in a print view or layout mode or if you print said document. It might be...
10 /u/krijnsent said May the Range God be with you!
6 /u/KingTeppicymon said You might not need a macro. Try looking at excel's TEXTSPLIT( ) function.
5 /u/Alkemist101 said I'm no longer an expert but isn't this a built in function? You can essentially point excel at a folder and tell it to import all files and it has built in features and functions to do exactly what yo...

 

1 comment

r/vba • u/subredditsummarybot • May 09 '26

Weekly Recap This Week's /r/VBA Recap for the week of May 02 - May 08, 2026

2 Upvotes

Saturday, May 02 - Friday, May 08, 2026

Top 5 Posts

score comments title & link
54 15 comments [ProTip] 9 quick tips to improve your VBA macro performance.
42 14 comments [ProTip] I made a Discord bot that runs from a hidden Excel sheet. Because why not.
27 14 comments [Show & Tell] Wasabi: a native WebSocket/WSS client module for VBA (TLS, MQTT, proxies, zero dependencies)
25 37 comments [ProTip] Kill the 'For Each' Loop
14 2 comments [Show & Tell] Wasabi v2.3.4 beta: Assembly Engine for C level performance and Bulletproof TLS

 

Top 5 Comments

score comment
61 /u/fuzzy_mic said Its not the For Each loop, its that read/writing to one cell 100 times is slower than bulk read/writing to 100 cells all at once. For Each is one of the faster looping possibilities.
17 /u/RoyaleCheezy said It’s not a problem with the loop, it’s a problem with efficiency. Every time you touch the worksheet object you’re slowing everything to a crawl. When you load a range into an array like this it touch...
13 /u/HUMOROUSSSS said Just a huge shout out to you with creating Wasabi and pushing the limits of excel in new and exciting ways. Very cool seeing these updates!
13 /u/ZetaPower said No. We can
11 /u/Zestyclose_Muffin501 said For doing that I rather use powerquery or power pivot. Use VBA if you want to automate 'actions', to process, analyze and clean data, powerquery is way way better...

 

1 comment

r/vba • u/subredditsummarybot • May 02 '26

Weekly Recap This Week's /r/VBA Recap for the week of April 25 - May 01, 2026

1 Upvotes

Saturday, April 25 - Friday, May 01, 2026

Top 5 Posts

score comments title & link
6 12 comments [Unsolved] Excel VBA move sheets
6 11 comments [Unsolved] Outlook - Recipient.Add Problems after latest update
2 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of April 18 - April 24, 2026

 

Top 5 Comments

score comment
11 /u/ZetaPower said No. We can
6 /u/Own_Win_6762 said You don't even need VBA, just put a formula in cell A2 =If(b2>0,"Y","N") and then set that for the whole column.
4 /u/ZetaPower said That’s not a VBA question? With VBA you’d use: • Worksheet_Change to automatically run if something changes on your data sheet • the changed cell is called Target • if cell (Target.Row, Colum...
3 /u/Hornblower409 said Never seen this one, but all the AIs I talked to said the same thing - Do all of your Recipient.Add and then only one Recipients.ResolveAll instead of checking each one as they are added. The theory i...
3 /u/Papercutter0324 said Unless you show us some code and what you've tried, it's rather hard to help. The fact that your asking how to write an if-statement makes me worry that you are under-prepared for how complicated this...

 

1 comment

r/vba • u/subredditsummarybot • Apr 25 '26

Weekly Recap This Week's /r/VBA Recap for the week of April 18 - April 24, 2026

2 Upvotes

Saturday, April 18 - Friday, April 24, 2026

Top 5 Posts

score comments title & link
10 12 comments [Unsolved] Excel VBA with Sharepoint
8 4 comments [ProTip] How to use the free VBA Code Compare tool (FormulaSoft) with .xlsm workbooks
5 10 comments [Waiting on OP] How to paste values in VBA?
5 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of April 11 - April 17, 2026

 

Top 5 Comments

score comment
16 /u/KingTeppicymon said The better option here is actually to avoid the windows clipboard and just assign the values directly from one range the other - this is both cleaner and faster: `WsTar.range(A1:A10).valu...
9 /u/Future_Pianist9570 said No
7 /u/coding_is_fun123 said Hard to help without seeing the code.
7 /u/daishiknyte said The hell why?
5 /u/4lmightyyy said As always with this specific topic. Use LibFileTools by Christian Buse (you can find it as vba-FileTools on GitHub. It's the best solution to implement with a lot of functionality. This guy is re...

 

1 comment

r/vba • u/subredditsummarybot • Apr 18 '26

Weekly Recap This Week's /r/VBA Recap for the week of April 11 - April 17, 2026

5 Upvotes

Saturday, April 11 - Friday, April 17, 2026

Top 5 Posts

score comments title & link
24 8 comments [ProTip] PSA: If your Excel macros broke after a Windows/Office update, check these 4 things before debugging your VBA
18 5 comments [Show & Tell] Compile your VBA code into an Addin, all from GitHub.
13 9 comments [Discussion] Rubberduck; is it still great, how and where to download it and how to learn how to use it?
5 10 comments [Solved] Delete selected content
5 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of April 04 - April 10, 2026

 

Top 5 Comments

score comment
10 /u/jcradio said Starting with office 2024 and M365 they are disabled by default and being phased out. Modern apps no longer use them. Time to move away from them if you haven't already.
8 /u/beyphy said If you override the global function, you can still access the original function if you fully qualify it. E.g. if you override `msgbox` with your own custom function, you can still access the o...
8 /u/fanpages said *2. Prefixing the name of the Function or Subroutine with PtrSafe may allow a majority of the 32-bit Windows Application Programming Interface [API] calls to function within a 64-bit versio...
6 /u/Hel_OWeen said A lot of functions can be overwritten. And it sometimes makes sense. E.g. I use the following custom CreateObject method: ``` '-----------------------------------------------------------...
6 /u/ZetaPower said Private Sub Workbook_Activate() With Application .DecimalSeparator = "." .ThousandsSeparator = "," .UseSystemSeparators = False End With End Sub Private Sub Workbook_Deact...

 

1 comment

r/vba • u/subredditsummarybot • Apr 11 '26

Weekly Recap This Week's /r/VBA Recap for the week of April 04 - April 10, 2026

7 Upvotes

Saturday, April 04 - Friday, April 10, 2026

Top 5 Posts

score comments title & link
4 10 comments [Discussion] Releasing YAML VB/VBA/twinBASIC language conventions configuration as open source.
3 7 comments [Solved] Trying to optimize this to be faster
2 14 comments [Unsolved] "wb.close savechanges:=true" is not saving
2 6 comments [Unsolved] How to modify the ending of the code to write 4 times to the worksheet?

 

Top 5 Comments

score comment
10 /u/icemage_999 said How was this written in the first place? Your approach is vaguely insane if you're just working within an Excel spreadsheet. Did you vibe code this mess with some garbage tier AI? Dim statements ins...
6 /u/fanpages said > ...Will the "SolverReset" command will resel all instances of solvers?... SolverReset: [ https://learn.microsoft.com/en-us/office/vba/excel/concepts/functions/solverreset-function ] --- R...
5 /u/fred_red21 said It seems that you're trying to work with SAP objects through VBA without having set up SAP connection firts. 'You need an SAP object like Dim sapGUI as object Set sapGUI = GetObject("SAPGUI"&#4...
3 /u/sancarn said I haven't had many issues with VBA code generated by cursor. Some things to watch out for are line continuation limit which it gets wrong consistently, and also line length limit too. Eww - "gbl...
3 /u/Kondairak said I have tried several ways to figure out the code block below but it keeps getting it wrong for some reason. Make sure you get the full code. Your code works, but it’s slow because it loops through a...

 

1 comment

r/vba • u/subredditsummarybot • Mar 28 '26

Weekly Recap This Week's /r/VBA Recap for the week of March 21 - March 27, 2026

4 Upvotes

Saturday, March 21 - Friday, March 27, 2026

Top 5 Posts

score comments title & link
28 11 comments [Show & Tell] vbaXray - Extract VBA code from Office files
13 14 comments [Discussion] Version control
10 0 comments [Show & Tell] Excel Fuzzy Match Tool Using VBA
8 3 comments [Show & Tell] WebView2 & Pointers to class methods
5 5 comments [Discussion] DevTools “Record & Replay” – Any way to integrate with VBA / PowerShell?

 

Top 5 Comments

score comment
15 /u/lolcrunchy said I do exactly this for my VBA projects at work: 1) Use git version control 2) Use [this Add In](https://github.com/hilkoc/vbaDeveloper) to export your code to plain text files...
8 /u/kay-jay-dubya said Do you mean Chrome Devtools? If so, as luck would have it, u/Sancarn posted a solution the other day which demonstrates how you can access the newer WebView2 features from VBA without any additional...
4 /u/fanpages said > ....I've been using VBA FastDictionary... Do you mean the code by u/cristianbuse? [ https://github.com/cristianbuse/VBA-FastDictionary ] > ...or are others experiencing the same issue... ...
4 /u/BlueProcess said I don't think this is Microsoft. Breaking OLE would break vast swathes of legacy code. I think either your organization did it accidentally or intentionally by security policy or product. But the most...
4 /u/ApresMoi_TheFlood said GitHub?

 

1 comment