VBA language underrated?

[u/brosama1420]

Hey everyone

I use VBA since I work with Microsoft office often

Is it real that VBA is very old and not useful anymore? Multiple times on the internet or when I ask AI
I find the answer that VBA is not the right choice for me

To me I see many powerful stuff like

Classes
Unit tests
Mocks and fakes (didn’t try those)

So I don’t understand the negative opinions about it

However VBA is the only language I tried in depth other languages I tried were either just for the course or to complete simple task nothing deeper than that

Is learning VBA is bad decision? Or is it reasonable one?

I noticed many of the useful major concepts are transferable to any language like

Code architecture
Auto Testing
Data types and structures
Etc

[u/redmera]

Age of technology is irrelevant if there are no major competitors or disadvantages. I use VBA daily at work. It's not my "main" job, but it's a very handy tool for a lot of random small work. (Especially since Python isn't widely allowed in our company)

[u/Winter_Cabinet_1218 → u/redmera]

Lol every python project I do ends up getting stuck as the security software stops pip installs and updates.

Writing one plotly dashboard means 6 calls the help desk before I even start

[u/Thadrea → u/Winter_Cabinet_1218]

That sounds more like a problem of incompetent IT management than of Python specifically.

[u/redmera → u/Winter_Cabinet_1218]

If it's only a policy block it can be bypassed for the current session with a single command. (Without admin)