Is PYTHON or VBA better? Which language should you learn?

Ohh man, I do need to login for commenting.
You got my subscribed + All Bell + my huge Respect.

I do agree with all what you said in this video. And, I think: Do not ask what programing language we should learn. But ask, Why do I have to learn that programing language.

Python is so so good. But that's not easy for you if you want to create your own commercial application. You need to learn a ton of knowledge for your goal. But, with VBA you can. also commercial application.

Just thing carefully, What you want to be. What will you do. Then start. If not, you'll spend a lot of time for learning but can not achieve your goal.

God Bless. Have a good day.

VBA has a steep learning curve

Another advantage of VBA is that it is almost 100% compatible with VB6, so if you want to compile something to an executable that can run outside of an office application it is fairly trivial. And there are new IDE/compilers like TwinBasic that are dragging the language kicking and screaming into the modern world.

Thana you very much for this in detail briefing. Love your videos.

I have experience in Advance Excel, i handle VBA which already created if is there any error occurs while running means my team mate (now he left from my company) guided me, so i can debug vba. In my project my company using Excel only. Right now no one know VBA in my team, mostly all our teammates are doing repetitive tasks every day. Now i m planning to learn VBA or Python i m not that much good in coding (i Know basic SQL, PLSQL) could you please any one suggest me which one i need to learn right now.(if i learn VBA is that good future? or directly can i learn python?) I m in confusing stage please help me.

and Office Scripts ? What do you think of it ?

It’s hard to find useful information on VBA.

for me, I'd stick with excel... python? no thanks...

This was a nice and clear presentation, though the reason why I really liked VBA is the debugging code Is awesome! I really miss that in python ...and also that stupid intend you use in loops can be really annoying ..in c# , Java and other languages I find that better. Python though can be very cool if you know how to program it ..and I agree the one is not superior over the other they are just there to make your life easier. Though one major point I would at is the execution speed. I think python might be way faster then vba

At the end of the day it depends what you're seeking to achieve . Vba within an office environment is fine particularly if you're willing to use Windows API's.
I'd suggest learning C in the first instance

Bravo!

Which will be given high package and VBA or phyton and which one is highly demand in MNC companies.

Very helpful. Especially seeing the two codes side by side gives the beginner a sense of the learning threshholds. Thanks!

Anytime you can avoid a MSFT product you are likely better off.

Thanks

If Microsoft doesn't plan to continue updating VBA, does that mean they might be phasing it out? That their applications will switch to Python as the primary coding method? That macros will start to record in Python? That people won't need a plug-in to code python in Office, in the future?

What if Microsoft were to open-source VBA. What can Python do that VBA cannot do? What can VBA not do versus what is VBA not allowed to do?

why isn't there any practical books on vba?

Good work. I worked a little project with VBA, but now I´ll use python instead

IMO python is windows 10 and vba is windows XP sure there’s plenty u can do on both but windows 10 is cleaner and more efficient also comes with programs that windows xp can’t run

Awesome explanation!

I'm a python web scraper and I have good grip on python, so, Should I go for VBA or continue with the python to handle excel problems?

Bawahaha wtf this isn't even debatable. Python

thanks

The main problem with VBAisn't necessarily the language itself,
but the HIDIOUS annoyingly clunky editor that comes with any programm, that makes use of VBA.

I'm used to VisualStudioCode
My biggest issues with VBE:

- I sometimes like to jump to another line in the code while I'm still coding in another line.
VBE then interrupts my workflow by telling me via msgBox, that the syntax is incorrect
"YES. I KNOW. I'm not done yet. Just highlight that line in red and LEAVE ME THE FUCK ALONE"

- Autocompletion doesn't show unless I hit Ctrl + Space, and if it shows, I specificely have to use TAB instead of Enter to fill that option in,
without jumping to a new line, which often results in a syntax-error, WHICH THEN RESULTS IN THE AFORE-MENTIONED MSG-BOX

- There are no keyboard-shortcuts to quickly move entire code lines up or down in the code (like ALT + up/down in vscode)
or select every instnaces of the currently selected letters (Ctrl + Shift + L in vscode)
or move the entire selcetion one indentation to the left or right

VBA with Excel feels super messy to me, dealing with cell references and all that, but more than anything I just can't stand having to save it with macros! I like that python doesn't ask, "Are you sure you wouldn't rather save this in a way that doesn't work?" Also, it drives me bonkers to keep switching from macro view to regular, and back. Finally, half the time I need to have it interact with legacy software, so Python is the only choice anyway - glad it's the one I prefer! Only downside, like you said, is getting permission for new software, even free.

Thank you so much for sharing this information!!. I just started learning Python two weeks ago and I have been using VBA for more than 20 years, so it is very important forr me to hear your opinion and as you said: I will try to use the right tool to have the job done.

In fairness I think it's a little unfair using any libraries in the python example. In the end though, in this specific example, I don't think it matters and I think that really goes to show how much effort you've put into providing a balanced argument! Well done :)

Regarding the advantages of VBA there are a few that you missed which I think are pretty big:
* Ability to make macro addins to enhance whole user experience across all workbooks. - This is only paralleled by VSTO addins.
* Ability to interact with Application events system - I think this is critical as you can do many simple things with events which is beyond most people's wildest dreams

Regarding the disadvantages of VBA:
* Restricted to Office Applications is actually not true anymore. TwinBasic is an implementation of VB7 (VBA) which works outside of Office, is fully compatible with Office, but compiles to EXE files. It also has additional features which are missing from traditional VBA/VB6.

So the only thing lacking from this video really, in my view, is VSTO/XLDNA and OfficeScript

Clear explanation.. Thanks a lot.

Thanks a lot for this video, it’s very clear and efficient.

Nice job Sven!

That's also how I feel - choose the right tool for the job! That said, I find myself using Python more and more even for small and quick automation things like renaming or moving files.


I also agree that some companies tend to block Python or .exe files. My solution to that was to build some must-have tools for my team, then give everyone training on Python. Now everyone is getting benefit from Python and they can't do some jobs without it 😂

As always great job, La Máquina!
Would be great to have the canteen menu as .exe 😉
Already looking forward to our TM1 videos 👍🏽

I learned so much from this video! Thank you!

I totally agree with your ideas in this video. It definitely makes sense to use the right tool for the right job. Thank you, and keeping going with these amazing videos.

Excelente!!

Very well prepared opinion, I love the metaphores used to illustrate.

I know a bit of VBA because I did some simple automations and a bit of code debugging on Excel. Now that I'm starting to learn Python, and with the basics that I've learned so far, I think VBA is easier to do without really learning how to code. Python on the other hand can be confusing but once you get to understand how functions work, I think it's actually fun. And with what you discussed, I think I'm on the right path because I'm pursuing a career in data analysis.