Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.