As soon as someone gets a better product than MS excel for the finance community they are in tough waters for relevancy. Gaming is the other one you pointed out.
You will probably not like them, but that doesn't make them vaporware.
VBA is kind of a wart in Office, hasn't been updated since 1998. They made an attempt of integrating a mini visual studio in Office with C#/VB.net (VSTA), then killed it.
I see many no code alternative poping up (Microsoft power suite, alteryx, etc). But all have a pretty steep learning curve, and frankly the people who are willing to invest the time to learn them migh as well pick up SQL or even python for the same effort.