How to use GitHub Copilot with VBA in Excel

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

God bless you. Been looking for a _long_ time to be able to edit contents of VBA editor from a proper text editor like VS Code. Even without copilot, this is a game changer. The VBA editor is so archaic when ever you open it up a sarcophagus in Egypt comes to life and a plague of flies is released.

michaelm
Автор

Wow, cant believe i found your video, its exactly what ive been lookkng for. Would you believe Bing GPT suggested your video. I'm completely new to GitHub but have been working on vba solidly for the last 12 months. Would this be able to read an existing xlsm file and help fix some bugs?

davidsmiththeaiguy
Автор

Oh my God! But this is a dream come true! VBA on VSCode. Why isn't this part of Excel officially?

UTJK.
Автор

This is so cool! Does xlwings auto-sync work with MS Access too? I'm an Access dev and would love to give this a shot

Sam-pgbw
Автор

Seems very promising, thanks for sharing!

Unfortunately I tried this and am getting "error walking file system: PermissionError [WinError 5] Access is denied: [path to local application data]". This happens even when I run VS Code as Administrator.

Any clues as to what might be the issue? Thanks

flexyourdata
Автор

great tutorial sir, i am getting one problem that if a cell is active(double clicked) in excel and i try to interact with that file, everything just hangs without giving any error, please provide solution to handle this situation please, thank you

darshanpanchal
Автор

How do you get VS to be your IDE for writing VBA on excel in the first place?

VC-oomi
join shbcf.ru