Відео

Great feature! Is it possible to work with folders in vscode? I know, they cant be synced to the vba project but it would make my life much easier if that would be possible. I tried creating a folder in vscode and move one .bas or .cls file into that folder but i get an error message in the terminal.

Have to say his changes to game for me capturing data and pushing it to db’s, thanks for creating this amazing tool Felix!

made my day!

is there a way to use xlwings to add a button to an excel sheet so i do not have to do it manually?

Definitely useful. Also, I just learnt a lot of new tricks on VS Code.

Good work, but Seems it should starts with installation steps, starting point missing. All vba user are not friendly with 'packages' stuffs

Amazing! Thank you!

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

how can i depoly an addin for excel?

3988 Barrows Overpass

Thansk man! pretty nice

Wow, your tutorial is amazing... Can you show if something similar is available for Libreoffice Calc..?

Xlwings is soo good, I just wish that when you edit some code fron vba, it recives correctily that characters such as ç or á, for a brazilian like me, it would be perfect. thanks XLwings for making my life a litle easier!

will this work with access

Omg i love it. I missed the tabbing in VB so much.

That’s incredible.. is there already a standalone version? Thanks for your work!

Just discovered your channel. I don't think a lot of people understand (yet) how powerful this is!

Felix, this is really great - when I looked at Office Script, I was quite pleased with its readability as compared to M in PowerQuery which I felt was very convoluted. But then the limitations are quite a bit and I have to resort to using Power Automate which is an UI-based tool. Very happy to learnt hat I can run a FastAPI backed to connect XL to my backend - that opens a lot of options for me. thank you so much for the detailed walkthrough of the MS Landscape for programming in Excel.

Felix, this is really impressive - this is such a valuable thing for a person like me who works with a lot of Excel but also want to reach out to a programming language to avoid the limitations of tools like PowerQuery.

I installed mkcert, but I can't find the certificates you mention it creates. It asks for a series of permissions. Very confusing

does this work with microsoft word as well?

One of the biggest attractions of VBA (for me, at least) is the VBE. Press Alt-11, insert module, write a function. It has intellisense, an object model I have memorized, instant type checking. Press F5. Is it possible to use xlwings to code python using Excel's VBE with all the niceties that we get from VBA? If not, is it on the roadmap?

Do you have a video that shows how to implement this POC demonstration?

太厉害了

Very nice - put a show stopper, that danish æøå are messed up when the code returns to Excel VBA

This tutorial is epic! Thank you

I'm interested in this. The AddIn can check differences about two binary coded VBA integrated Codes? I researched, but got no trustable source, which software could do this?

I was so excited about this, but something seems off with this module. When running " xlwings vba edit", I get this error: "Please install watchgod to use this functionality", although I already installed it :(

There are MANY books on python out there (some good, some great, some absolutely crap) but if you have worked on microsoft excel before and want to learn python (specifically for data analysis) this is the book i personally used and would highly recommend...

Excel application shows manifest-officejs-hello.xml is invalid. Looks like it's something started happening recently. Any idea what's causing it.

Thank you very much! Amazing content!

It was only ever about Dark Mode

4:02 You can comment out multiple lines in the VBA IDE by attaching an accelerator key C to the comment quick action, and U to the uncomment quick actions.

but how to debug with vba in vs code ide? thanks

I download the xlwings-main file from github but cannot manage to import the xlwings into my python code successfully. I ran, into the xlwings-mai file, python setup.py --user (or something like that), it didn't seem to end well and then i'm left in this state, what do I miss ? I'm working on a linux virtual machine and cannot use pip for administrative rights that I don't have, thank you for your help in advance !

¡Gracias!

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

is there a way of working with multiple workbooks?

olá. eu quero somente rodar o vba escrito no vscode no excel, nao quero fazer alteracoes mais afundo, so isso mesmo... é necessario todos estes arquivos? pq como uso muito vba, vai ser um grande volume de arquivos se forem tantos arquivos para cada projeto vba... tem como usar so 1 arquivo? como faço?

its a game changer. thank you!

Great video! Minor comment: @function_name is optional and you can skip it to make the code even smaller

incredible

I cant do it, can you help me? please! error is: "xlwings" no se reconoce como un comando interno o externo, programa o archivo por lotes ejecutable.

A very handy way to get vba-code under git-control! That is the most important for me. Thanks! As an alternative editor it's less interesting as intelisense and debugging isn't there

Amazing work!! Finally, I can use VBA at my work! I wouldn't say I like the VBE; because of it, I always stay far away from VBA.

That is just Great was looking for such a tool for years

Been using my own solution for two years because the VBE is so bad, this is amazing! Thanks!

I just wanted to thank you for your book Python For Excel which I am nearly done reading. It was a grand introduction which gives me a lot of confidence in pursuing programming! Thanks from Philadelphia, USA!

Amazing addition! Thank you for the explanation!

*Very cool addition to xlwings, Felix!* Totally agree. The Excel formula bar is for sure not the best code "editor" 😅