I'm not new to programming—I know various languages and often deal with Excel automation in my job. I've come across a lot of legacy VBA, though I haven't dived into coding it myself. I want to know if it's worth my time to learn VBA deeply, beyond just maintaining old code. I've heard that many companies are moving away from VBA due to security concerns and opting for other languages instead. What's the consensus on investing time in this language now?
4 Answers
It sounds like VBA is still part of your workflow at work. Learning it can definitely save you time when dealing with legacy code. Plus, being skilled in updating this kind of code is a valuable asset since not many can do it well. But if you don’t need it for your job, I’d suggest focusing on languages that are more in demand right now.
If you're getting paid to use it, then definitely! Some companies still rely on VBA for specific tasks, even while moving towards other options. But learning it can still add value, especially if it helps with automation at your job. Just consider your specific situation.
I think it really depends on your organization. If they're using VBA actively, investing time to learn it makes sense. The macro recorder is a great place to start since it's user-friendly. Companies that utilize VBA definitely find it easier to create new scripts than to fix someone's old code. Just be aware that finding fresh resources for learning VBA is getting tougher since everyone seems focused on trending languages now.
Honestly, I started with VBA too and found it decent, but it has its quirks. Comparing it to languages like Python or C++, it falls short in robustness. If you're not required to learn it for work, maybe consider investing your energy into those better languages instead.
Related Questions
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically
[Centos] Delete All Files And Folders That Contain a String