从Excel调用Web服务最简单的方法是什么(我正在使用版本2002)?请不要第三方工具或图书馆。这一点很简单,一些VBA可以粘贴到那里,使用它,然后触摸。
What is the easiest way to call a web service from Excel (I am using version 2002)? Please, no third party tools or libraries. This has to be easy with some VBA that I can paste there, use it, and ever touch.
推荐答案我不认为有直接从VBA直接与SOAP进行通信的特别简单的方法,但是具有RESTful接口的Web服务(即整个事情可以通过URL完成)更容易:我正在查看这篇文章今天。我刚才发现的另一篇文章是 here 。
I don't think there is any especially easy way to talk to SOAP directly from VBA, but a web service with a RESTful interface (i.e. the whole thing can be done via a URL) is easier: I was looking at this article just today. Another article I just found is here.
然而,如果您遇到了SOAP,您可以先阅读这个和此。坦白说,这看起来有点讨厌。
If you're stuck with SOAP, however, you could start by reading this and this. Frankly, it all looks a bit nasty.
更多推荐
我可以使用什么方法从VBA调用Web服务?
发布评论