Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to consume a SOAP web service from excel. Now according to This article (and confirmed by other articles and MSDN) if I do the following:

  • Install the web services toolkit (I've installed v2.01)
  • Install SOAP Toolkit 3.0
  • Add a reference to Microsoft Soap Type Library (I've tried v3.0 and an older one)

I should get a "Web Service References" menu item in the Tools menu but I don't.

I've also tried adding every reference that seemed to have anything to do with SOAP or XML, but it hasn't helped.

Any ideas?

share|improve this question

Just a guess but did you try closing excel & reopening to see if it refreshes, hoping everything else is done right ?

from the article: "Tools → Macro → Visual Basic Editor. On the Tools menu of the VBE, you'll find Web Services References"

share|improve this answer
Tried that, but no change. The Tools menu of the VBE has no such item. – Draemon Feb 18 '10 at 18:31
What version of Office r u using ? – SoftwareGeek Feb 18 '10 at 21:52
Office 2003 – Draemon Feb 19 '10 at 16:22
Ok, try to reboot your machine, see if that helps. – SoftwareGeek Feb 19 '10 at 16:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.