SharePoint 是否支持 VBA？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6281088/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Does SharePoint Support VBA?
提问by Justin
I have read very little content regarding Sharepoint (SP), and most of my reading has been sales pitch oriented overview material. I utilitze VBA with Office apps - especially Access - on a regular basis, and I am wondering if there is any translatable way to retain the custom functionality of writing my own VBA within Sharepoint, especially with MS Access.
我读过的关于 Sharepoint (SP) 的内容很少，而且我的大部分阅读都是面向销售宣传的概述材料。我定期将 VBA 与 Office 应用程序（尤其是 Access）一起使用，我想知道是否有任何可翻译的方式来保留在 Sharepoint 中编写自己的 VBA 的自定义功能，尤其是使用 MS Access。
I have read that Access databases can be run on SP, with tbales to list and forms to InfoPath, but I am assuming they are primarily talking about Access database apps that were built with wizards, which consist mainly of bound objects without explicitly-defined code.
我已经读过 Access 数据库可以在 SP 上运行，使用 tbales 列出 InfoPath，但我假设他们主要谈论的是使用向导构建的 Access 数据库应用程序，这些应用程序主要由绑定对象组成，没有明确定义的代码.
Most of my app are primarily code driven with VBA because of my automation requirements, which I rely on to perform my tasks. Am I going to be able to accomplish the same thing within SP, and could anyone please provide any references on the subject, specifically?
由于我的自动化要求，我的大部分应用程序主要是用 VBA 代码驱动的，我依靠它来执行我的任务。我是否能够在 SP 中完成同样的事情，任何人都可以提供有关该主题的任何参考资料吗？
采纳答案by David-W-Fenton
You can use Access to distribute your front end to users, regardless of how much VBA it has, but an app with VBA code in it will not convert to run in the browser as a Web Database within Sharepoint 2010's Access Services. For that to work, you have to use the new, more powerful macros and limit yourself to the features supported by web objects. For an existing app, this means rebuilding every object from scratch.
您可以使用 Access 将您的前端分发给用户，无论它有多少 VBA，但其中包含 VBA 代码的应用程序不会转换为在浏览器中作为 Sharepoint 2010 的 Access Services 中的 Web 数据库运行。为此，您必须使用新的、功能更强大的宏，并将自己限制在 Web 对象支持的功能上。对于现有的应用程序，这意味着从头开始重建每个对象。
Do you need to run your Access app in a web browser? If not, then you're barking up the wrong tree here.
是否需要在 Web 浏览器中运行 Access 应用程序？如果没有，那么你在这里吠错了树。
回答by Charles Williams
AFAIK Sharepoint does not support VBA.
AFAIK Sharepoint 不支持 VBA。
回答by Coder375
If you publish an Access database to SharePoint as a web database it cannot use VBA, however you can create a hybrid with the tables in sharepoint and the frontend in Access, that way you can have as much VBA etc as you want and still have the advantages of your data being stored in the SharePoint SQL server. You can store the frontend on Sharepoint and have users download it through sharepoint.
如果您将 Access 数据库作为 Web 数据库发布到 SharePoint，则它不能使用 VBA，但是您可以使用 sharepoint 中的表和 Access 中的前端创建混合，这样您就可以拥有尽可能多的 VBA 等，并且仍然拥有将数据存储在 SharePoint SQL 服务器中的优势。您可以将前端存储在 Sharepoint 上，并让用户通过 sharepoint 下载它。
The alternative is to keep a traditional Access database on the Sharepoint Share and access it via webDAV rather than the Sharepoint web interface. You could map the sharepoint library as a local drive to make it easy.
另一种方法是在 Sharepoint Share 上保留一个传统的 Access 数据库，并通过 webDAV 而不是 Sharepoint Web 界面访问它。您可以将 sharepoint 库映射为本地驱动器以简化操作。
