vba 适用于 Office 2007 的 MS Office Webservice 工具包？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3797672/
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
MS Office Webservice toolkit for Office 2007?
提问by user310291
There is an article here for MS Office 2003 http://metrix.fcny.org/wiki/display/tips/How+to+Create+a+Microsoft+Access+Client+for+a+SOAP-based+Web+Service+API
这里有一篇关于 MS Office 2003 http://metrix.fcny.org/wiki/display/tips/How+to+Create+a+Microsoft+Access+Client+for+a+SOAP-based+Web+Service的文章 +API
When I tried to install http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fa36018a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=enit says it requires Office 2003 whereas I have Office 2007 and I can't find update for Office 2007 ?
当我尝试安装http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fa36018a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=en 时，它说它需要 Office 2003 而我有 Office 2007，我可以没有找到 Office 2007 的更新？
Does it exist if not how do I access a soap webservice from VBA ?
它是否存在，如果不存在，我如何从 VBA 访问soap web 服务？
回答by Garett
I believe the Web Services Toolkit used the SOAP toolkit, which is no longer supported. However, there are a couple of options available, which include:
我相信 Web 服务工具包使用了不再受支持的 SOAP 工具包。但是，有几个选项可用，其中包括：
- XMLHTTP- Relies on WinInet.
- ServerXMLHTTP- Offers much of the same functionality as XMLHTTP, but does not rely on WinInet. See the FAQfor more information.
- Managed Code- Using .NET utilizing VSTO or an Excel Workbook project.
- XMLHTTP- 依赖于WinInet。
- ServerXMLHTTP- 提供许多与 XMLHTTP 相同的功能，但不依赖于 WinInet。有关更多信息，请参阅常见问题解答。
- 托管代码- 使用 .NET 利用 VSTO 或 Excel 工作簿项目。
Here are a few examples.
这里有一些例子。
http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/#_Toc173749360
http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/#_Toc173749360
http://msdn.microsoft.com/en-us/library/dd819156%28office.12%29.aspx
http://msdn.microsoft.com/en-us/library/dd819156%28office.12%29.aspx
http://msdn.microsoft.com/en-us/library/aa168471%28office.11%29.aspx
http://msdn.microsoft.com/en-us/library/aa168471%28office.11%29.aspx
