适用于 Office 2007 的 MS Office Webservice 工具包? [英] MS Office Webservice toolkit for Office 2007?

问题描述

这里有一篇关于 MS Office 2003 的文章http://metrix.fcny.org/wiki/display/tips/How+to+Create+a+Microsoft+Access+Client+for+a+SOAP-based+Web+Service+API

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

当我尝试安装 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fa36018a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=en 它说它需要 Office 2003 而我有 Office2007 并且我找不到 Office 2007 的更新?

When I tried to install http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fa36018a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=en it says it requires Office 2003 whereas I have Office 2007 and I can't find update for Office 2007 ?

它是否存在，如果不存在，我如何从 VBA 访问 soap 网络服务?

Does it exist if not how do I access a soap webservice from VBA ?

推荐答案

我相信 Web 服务工具包使用了不再受支持的 SOAP 工具包.但是，有几个选项可用，其中包括:

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:

• XMLHTTP - 依赖WinInet.
• ServerXMLHTTP - 提供大部分与 XMLHTTP 相同的功能，但不依赖于 WinInet.有关详细信息，请参阅常见问题解答.
• 托管代码 - 利用 VSTO 或 Excel 工作簿项目使用 .NET.

• XMLHTTP - Relies on WinInet.
• ServerXMLHTTP - Offers much of the same functionality as XMLHTTP, but does not rely on WinInet. See the FAQ for more information.
• Managed Code - Using .NET utilizing VSTO or an Excel Workbook project.

这里有几个例子.

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/aa168471%28office.11​​%29.aspx

这篇关于适用于 Office 2007 的 MS Office Webservice 工具包?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！