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.
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?
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
This is likely an issue with how you run xlwings.exe, so probably best to run it from a Command Prompt that you start with admin privileges (right click > Run as administrator). I don't think that when you start VS Code as admin it automatically runs the Terminal as admin, too.
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
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.
bro I laughed so hard at the metaphor, so true. Looks like Microsoft gave up on that editor two decades ago
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?
Possibly yes, although I would expect the next version (Copilot X) that will work more like Chat GPT, to be even more suited for that use case
Oh my God! But this is a dream come true! VBA on VSCode. Why isn't this part of Excel officially?
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
It’s Excel only but the code is open source and you could port it to work wit Access by using Python/pywin32 directly.
@@xlwings9689 I stumbled through the edits (took me forever to find it) but I got it working in Access! Thanks for the suggestion, this is incredible!
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
This is likely an issue with how you run xlwings.exe, so probably best to run it from a Command Prompt that you start with admin privileges (right click > Run as administrator). I don't think that when you start VS Code as admin it automatically runs the Terminal as admin, too.
How do you get VS to be your IDE for writing VBA on excel in the first place?
ua-cam.com/video/xoO-Fx0fTpM/v-deo.html
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
its a game changer. thank you!