Microsoft Says VBA Is Here To Stay
Angostura writes "Microsoft's team blog for Microsoft Excel and Excel Services has responded with a denial to the earlier report that Visual Basic for Applications will disappear from Windows Office in 2009. The Slashdot discussion on the report on Tuesday got pretty animated."
Oh thank god... don't know what I'd do without that!
Customers don't want VBA to go away.
They want the damn ribbon to go away!
There is no mod option "-1: Disagree" for a reason. "Overrated" is not an acceptable substitute. Post something instead.
Agreed. VBA obviously can't be part of the ISO-ificated OOXML. VBA is probably going to be considered a 'legacy' feature, with recommendations that customers do new development on VSTA/VSTO.
If history is any judge, many VBA apps will one day not work in future versions of Office anyhow. MSFT does plenty to break compatibility between releases. In fact, some VBA apps developed for Office 97 won't work on Office 2000 or later.
My blog
Actually, that should happen sooner rather than later, so this announcement is a retrograde step.
DDE, OLE, COM and DCOM are fundamentally flawed models which were developed in a much less fraught security environment than we have now. VBA is heavily tied into that same flawed architecture.
Microsoft has tried to address the exposures by disabling macros by default in Office, but the control they provide isn't fine-grained enough to do more than pass the buck to the customers who have to enable the lower security levels to get their documents working.
They do have an answer in .NET, but until Office is re-written for that platform, and until there's some sort of converter for the massive collection of existing VBA to VBA.NET, they're stuck with the risky and clunky security fix.
"I've got more toys than Teruhisa Kitahara."
Has anyone actually read the original explanation for why Office 2008 isn't getting VBA?
http://www.schwieb.com/blog/2006/08/08/saying-goodbye-to-visual-basic/
Which makes it very clear that there are good technological reasons for dropping it. Or, at least, it's going to be such a huge amount of work to bring it natively to Intel that it's not worth it to MS.
I mean, sure, some people at MS may be happy about it vanishing, but it doesn't sound like a conspiracy to me...
My Journal