我可以使用什么方法从VBA调用Web服务？

本文介绍了我可以使用什么方法从VBA调用Web服务？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

从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.