I am a data analyst at an energy company. I recently had to automate a few Microsoft Excel functions for a colleague using VBA, although I had initially written the code in Python. That got me thinking if VBA is still widely used in the tech world? I'm new to the tech industry. Any suggestions, feedback and tips are appreciated! Thanks :)
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (17)
Excel is very important in finance. VBA is frequently written by non-software folks to solve problems faster. Eventually the code becomes a critical workflow. You can add value by being able to update or convert that into a more stable, supportable software systems. There is a demand for that specialty if you like upgrading things.
True! I work in the credit/finance department and VBA is used by all the non-software people there. I'd like to be able to code in Python but it is what it is. Gotta conform to the company preferences and protocols :3
You may be able to run python with XLWings or similar within Excel. You can always make suggestions and remind them python is growing in popularity.
VBA is a case similar to COBOL, though thankfully there's probably far less code written in it that's critical for international infrastructure (there are a lot of big financial institutions that still depend heavily on COBOL).
Realistically, you're not likely to encounter it with any significant frequency unless you work at a company that insists on not moving to newer alternatives.
I've never used COBOL haha, but agree about finance institutions relying on VBA/COBOL
VBA will stay relevant as long as Excel stays relevant, because while there are ways to automate Excel using other languages, they require more ceremony and you can't bundle their code in the spreadsheet file.
(And yes, VBA can be used to automate other MS Office products, but Excel probably has the lion share here)
Agree! Sometimes using VBA becomes a matter of contextual convenience.
I worked as a Certified Management accountant. I almost made a career writing VBA code, in Excel but also Access. It is vital when there are many files and systems and there is no properly built tool for everything. I worked with many junior accountants and I automatized many workflows using Excel and VBA. I think it is relevant to know it.
If Access have better capabilities for data management why do you think that is more popular Excel for these tasks? I think Access should be the King y that cases. Thank you.
Excel is more flexible and can be understood even by non-technical people. I rarely see Access, but Excel is everywhere.
I don't think it is. Like others have said there is probably some legacy stuff floating around.
That said I still use it every now and then. Sometimes excel is the right tool for the job and sometimes you need to extend excel just a bit with a custom function. I know just enough to add a bit of functionality.
Agree about the legacy stuff!
I think this is not an skill to develope for people starting in this world. Now, there are more options and, overall, more powerful tools for doing the kind of stuff VBA does. As an example, take a look on PowerBI and it's Report Designer, charts are so easy to implement. Doing other kind of tasks like cell calculation from other values can be adpat to other applications, you have the O365 suite with SharePoint, PowerApps and Flow that let people work in the cloud and not be chained to the desktop.
To wrap up, VBA is still used nowadays but in the same way as Cobol, people that has very important processes running that doesn't want to change for lot of reasons like money, time, etc.
For example, at the university I've learnt VBA for a semester. After I've found for me GAS (Google Apps Script) and ExcelJs, which are more comfortable for developing some feature for excel
Will check out GAS and ExcelJS! :)
Glad to answer for any questions
Excel is probably one of the biggest application platforms in the world, unfortunately. There are companies out there where major operations take place in a magic spreadsheet that was designed 10 years ago by some bored intern who is now long-gone. No one understands how it works or what it does, and it breaks if you stare at it the wrong way. So they deal with it because no one wants to decipher the requirements represented by that application.
There's always going to be a place for it, but it probably is not the place that you want to be! If it really is super important, wait until they have resigned to paying a consultant $150/hr to figure it out and counteroffer :P