VBA 的未来是什么？
通过新的 2007 版 MS-Office，Microsoft 开始使用 VBA 来“威胁” href="http://en.wikipedia.org/wiki/VSTA#Future" rel="nofollow noreferrer">VSTA。 由于 VBA 非常常用，您认为未来 3-5 年脚本开发的前景如何？
或者，会不会像VB6一样突然被杀掉？
Autodesk 在听说后也放弃了它（有点）来自MS的消息。
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我建议VB6不会突然被杀死。 也许是官方 MS 支持，但 VB6 和 VBA 在这里。
与任何拥有广泛用户/客户/第三方供应商基础的技术一样，VBA 作为脚本技术需要很长时间才能消失。 我想象它的后继者需要数年时间才能完全超越 VBA。
I'd suggest that VB6 wasn't killed suddenly. Official MS support, perhaps, but still the community is alive for both VB6 and VBA here on SO.
As with any technology with a WIDE user/customer/3rd party vendor base, it will take a long time for VBA as a scripting technology to fade away. I would imagine that it will take years for its successor to fully overtake VBA.
同意 Dick Kusleika 关于部署的
观点 弃用 VBA 的问题是：
Agree with Dick Kusleika about deployment
The problems with deprecating VBA are:
在我看来，它会死，但不会突然死。 Excel 曾经有一种名为 XLM 的宏语言 - 基本上是一种增强型键盘播放功能。 XLM 仍然受到支持，而且很容易就有十几个人在使用它。 这就是为什么我认为 VBA 将会存在相当长一段时间。 它不会被更新、支持，甚至可能不会被承认，但它将会可用。
MS 迟早会将 .NET 与 Office 应用程序集成，并且更少的人会关心 VBA。 现在，我可以将一些 VBA 放入 Excel 电子表格中，将其发送到客户端，然后部署就完成了。 我可以告诉 IT 部门这是一个带有宏的 Excel 工作簿，他们不会感到受到威胁，因为他们不知道更多。 当 .NET 具有如此简单的部署选项时，我将使用它。 那一天终将到来，VBA 将慢慢开始消失。
It will die, IMO, but not suddenly. Excel used to have a macro language called XLM - basically a keyboard playback on steroids. XLM is still supported, and there's easily a dozen people who use it. That's why I think VBA will be around for quite a while. It won't be updated, supported, and maybe not even acknowledged, but it will be available.
Sooner or later MS will integrate .NET with Office apps and fewer people will care about VBA. Right now, I can put some VBA in an Excel spreadsheet, send it to a client, and deployment is done. I can tell the IT department it's an Excel workbook with macros, and they don't feel threatened because they don't know any better. When .NET has deployment options that simple, I'll use it instead. That day will come and VBA will slowly start fading away.
语言已经改变& 完成事情的方式（即拖/放表单、创建宏、修改几行然后就完成了）也会改变。
它不会仍然是一个非开发人员会发现易于使用的工具。
基本内容（工作簿、工作表、范围）等的对象模型应保持相同。
将添加一系列新的东西 这将改变对象模型& 因此新的学习（例如功能区界面）
不要忘记，.net 带来了它自己的概念/复杂性。
The language has changed & the way things were done (i.e. drag/drop form, create a macro, modify a few line & you are done) will also change.
It won't remain a tool, which a non-developer will find easy to use.
Object model should remain same for basic stuff (Workbook, Worksheet, Range) etc.
New set of things will get added & that will change the object model & hence new learning (e.g. Ribbon Interface)
Not to forget, .net brings in its own concepts/complexity.