I work at an investment bank and I have daily contact with VB. It's awful and I wish it had some modern features like try catch blocks, but to automate simple t

I work at an investment bank and I have daily contact with VB. It's awful and I wish it had some modern features like try catch blocks, but to automate simple tasks in Excel or Outlook it seems to be the only option. Though powershell shows promise it doesn't run inside the Excel runtime and its a pain convincing others to use it.