我可以使用什么方法从VBA调用Web服务？ [英] What method can I use to call a web service from VBA?

问题描述

从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服务？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！