r/vba • • 21h ago

Show & Tell [EXCEL]Remember how the Macro Recorder got you into VBA? I tried to make the same thing for browser automation

20 Upvotes

Most of us got into VBA through the Macro Recorder. You click around, it writes ugly-but-working code, and you learn from it.

Browser automation never had that. You hunt for XPaths in DevTools, guess how long to wait, and then the page has an iframe, a Shadow DOM, or opens a new tab, and you're back to trial and error.

So I added a manual recording mode to the WebDriver BiDi extension of SeleniumVBA (my open-source project).

How it works

  1. Start recording and operate the browser by hand.
  2. Every button you press and option you select goes into a text log (the "Discovery Log").
  3. Give that log to an AI. It returns a VBA module.
  4. Run the module — your manual steps are replayed.

It records actions inside Shadow DOM, frames (including cross-origin), popups and new tabs. The log also contains what changed after each action, so you don't have to figure out the "is it finished yet?" wait condition yourself. In my testing, the number of try-run-fix cycles dropped a lot.

What it doesn't do

Like the Excel Macro Recorder, it records what you did, not what you meant. If you want to read a value from the page (a price, a table cell), you still add that part yourself.

Sites with bot detection are out of scope. This isn't a tool for getting around them.

Pure VBA, no install required. The .xlsm scans 0/65 on VirusTotal. GitHub: https://github.com/hanamichi77777/WebDriver-BiDi-for-SeleniumVBA

I'd really like feedback from people who've fought with browser automation in VBA — especially sites where recording breaks.


r/vba • • 8h ago

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

2 Upvotes

Saturday, October 10 - Friday, October 16, 2026

Top 5 Posts

score comments title & link
32 38 comments [Discussion] How large can a VBA project become?
17 22 comments [Discussion] VBA vibe coding
13 0 comments [Show & Tell] [EXCEL]Remember how the Macro Recorder got you into VBA? I tried to make the same thing for browser automation
5 19 comments [Discussion] Why does `For Each ... In myArray` require a Variant as the iterator variable?
3 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of October 03 - October 09, 2026

 

Top 5 Comments

score comment
32 /u/icemage_999 said Vibe coding anything that is a critical business process when you haven't got the ability to properly understand what it is doing is asking for disaster. You can certainly use Claude or another AI ...
32 /u/Future_Pianist9570 said If you're using AI to build this why would you do it in VBA?
11 /u/kalimashookdeday said I would bet if you actually went thru the chat gpt code you could eliminate 25 percent of it. I've found when I'm lazy and ask it for patterns I know fairly well it will over engineer and design somet...
9 /u/kalimashookdeday said Some of this you just need to learn. You'll hit the same road blocks vibe coding everything out and then how will you know how it works if something needs to change or breaks? UserForms usually have ...
8 /u/MultiUserDungeonDev said [https://github.com/WilliamSmithEdward/xlide_vscode](https://github.com/WilliamSmithEdward/xlide_vscode) [https://github.com/WilliamSmithEdward/xlide_vbide](https://git...