Re: Cue all the usual stuff about incompatibility etc
Very true, though I wonder for how long VBA is going to live on.
Microsoft have four office automation interfaces in Office as of now: VBA, .Net (Visual Studio Tools for Office), Office Add-ins (html?) and now (Office 2016) enhanced Office Add-ins (Javascript). Only the fourth seems to offer the kind of document automation that VBA excels at (because it has access to the COM model). The other two could do that sort of thing, but it is perverse: they are more suited to application automation, e.g. mailing a list of contacts when the web stock-price widget you added to Outlook tells you you are rich.
Isn't it likely that Microsoft desperately want to be shot of VBA in favor of JavaScript? Having people develop a minority development platform is not a good use of their resources compared to having their people develop the best JavaScript engine in town.
Biting the hand that feeds IT
