You may be asking, Isn't Visual Basic for Application, like old and a dumbed down version of it's .Net counterpart?
HA! I mean... yes... But let me ask you, what is the one software every single accounting firm, investment bank, and financial department must have?
EXCEL!
Take out any other software and a competitor sweeps in, but take out Excel, and the industry grinds to a stop and shatters into pieces. Although these companies are slowly migrating their data to the cloud, in more resilient formats such as SQL databases or even csv files, they are still dependant on Excel.
8 out 10 times, an automation process that needs to be done, can be done in an Excel macro, without the need of any new expensive RPA system.
Projects
Excel based database
Excel as a database is sacriligious, until you realize that for small businesses, this is not only a viable option but actually, the best option. Using a sheet per table, and VBA to unlock, create, edit, or delete, and lock these password protected sheets, I can replicate a database at 0 cost for the business.
Labeling application for AI Training
Sometimes you need to get up and running quickly, or tech will leave you behind. If you want to get in the latest tech, like AI, you need data, tons of it. I developed a VBA App to read, edit, and tag transcripts to gather data, in a format that is ready to upload to web, to a database, or to train AI with.