It is highly unlikely VBA will be going away. They said that about COBAL and other languages, but look at them now...they are alive and well but have "grown up" a lot.

VBA is the basic interface for all of the Microsoft products and many other programs as well.

I cannot imagine it going away.