2

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.

Community
  • 1
  • 1
AlanR
  • 1,162
  • 4
  • 14
  • 26
  • Here you go: http://msdn.microsoft.com/en-us/library/aa140260.aspx – Sam Schutte Sep 23 '08 at 18:34
  • yea, thanks. I was planning to answer this one myself after spending 20 minutes before landing on the website you put down :). – AlanR Sep 23 '08 at 18:47
  • :) 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 Sep 24 '08 at 14:45

1 Answers1

2

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
  • 51,832
  • 12
  • 88
  • 127