There are countless backoffice apps written in VBA/Macros. MS Office versions from 97-2007 are so ubiquitous in today's world that a VBA code "sea change" is IMHO unattainable. Additionally, considering MS Office is a multi-billion dollar cash cow for
the company, I strongly doubt they would do something radical as eliminating VBA completely any time soon, if ever.
Reading between the lines of this interview, it sounds to me like VB.NET and C# will eventually meet into one language. Visual Basic .NET was created as an entrance ramp for Visual Basic 6 programmers to get on the Object Oriented/.NET super highway. Just
like Microsoft closed the road on VB 6, they will do the same for VB.NET and bring everyone into one camp within the next 4-10 years.