There is an article her开发者_开发知识库e 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
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 ?
Does it exist if not how do I access a soap webservice from VBA ?
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 - 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.
Here are a few examples.
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
精彩评论