VS Code + Excel VBA: Write Better Macros Faster

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video tutorial, I'll show you how to use VS Code to write and run VBA macros for Excel with the help of xlwings. You'll learn how to connect your workbook to VS Code, sync changes instantly, and use tools like Codeium to generate VBA code automatically. This setup makes coding much easier with features like syntax highlighting, AI tools, and more. Follow along to upgrade your VBA workflow and make Excel coding faster and smarter!

🌍 𝗟𝗜𝗡𝗞𝗦:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[lucaa.]

Just wanted to say thank you for this incredibly helpful and well-structured video! I really appreciated how clearly you explained the use of Codium AI for generating VBA macros for Excel — it’s a use case I hadn’t seen covered in such a clear way before.
Your walkthrough made the process feel approachable, even for someone who isn’t a full-time developer. I especially liked how you highlighted the strengths of Codium when it comes to transparency and explanation of the generated code.
Really valuable content — please keep sharing more like this! 🙌

[shanghainewbison]

This is very useful for my work. None of my coworkers are software engineers, and they only use Excel for their daily work.

[Radulf]

Nice, until now, I copied the code into a new file, edited it and then copied it back… this way is way smarter. :) Thanks for this Video!

[Dr_Dorian]

My mistake... thanks for the great video. :D

[MohammadRezaEslami-du]

It was very useful. thank you for sharing. help me learn VBA and implement it.

[harmonygears]

Small hint regarding 2:45 - you can also link the file to the system env path and also will be able to call it from anywhere

[andreamazzai]

Hi Sven, are you aware if it's possible to edit XLAM files in VSCode? I have a macro in Excel Addins folder that automates some tasks into CSV or XLSX files that are generated from our corporate tools; I update the macro from time to time and I distribute it to my colleagues.

[danbromberg]

After I ran the '...xlwings vba edit...' command in my VSC Terminal, these messages were issued in my VSC session:
Proceed? [Y/n] y
NOTE: Deleting a VBA module here will also delete it in the VBA editor!
Watching for changes in DRBrosmini.xlsm (silent mode)...(Hit Ctrl-C to stop)
I think that means it was working, so are these the messages I should expect whenever I run xlwings in VSC?
Thank you,
Dan

[danbromberg]

Where does that CLICK ME button at 0:24 come from? Is there a prerequisite video I should've watched?

[jgarale]

hi!! :) which theme do you use in Visual Studio Code?

[danbromberg]

Instead of copying 'xlwings' to my Windows directory as you suggested (I prefer to keep it vanilla), do you see any downside to instead modifying my PATH environment variable to include 'xlwings'?

[danbromberg]

Can you suggest a VBA debugger extension for VSC? I get this error when I try to debug in VSC: "You don't have an extension for debugging avb. Should we find a avb extension in the Marketplace?"

[_MnK]

Огромное спасибо, добрый человек! 🔥
Это описание реально дало возможность работы с кодом VBA в VSCode.
Я пока не очень разобрался, конечно, но у меня показывает только Module1.bas, Sheet1.cls и ThisBook.cls.
Но моя Workbook содержит 15+ worksheets и около 20 modules.
Если это возможно, то подскажите, пожалуйста, можно ли сделать, чтобы все листы и модули были доступны для редактирования?