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.
yea, thanks. I was planning to answer this one myself after spending 20 minutes before landing on the website you put down :).
AlanR
2008-09-23 18:47:14
:) Ain't that always the way it goes? There ought to be a way to have SO alert you when someone answers your question, because I think I posted this link pretty soon after you posted the question, which might have saved you some time. :)
Sam Schutte
2008-09-24 14:45:54
+1
A:
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.
If you're stuck with SOAP, however, you could start by reading this and this. Frankly, it all looks a bit nasty.
Mike Woodhouse
2008-09-23 19:54:56