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.