Why don't I have a "Web Service References" menu item in excel/VBA?

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?

Draemon

Posted 2010-02-18T16:14:49.703

Reputation: 738

I have the same problem, have you found a solution since? – sinsedrix – 2017-06-06T13:35:45.953

Answers

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"

SoftwareGeek

Posted 2010-02-18T16:14:49.703

Reputation: 891

Tried that, but no change. The Tools menu of the VBE has no such item. – Draemon – 2010-02-18T18:31:53.993

What version of Office r u using ? – SoftwareGeek – 2010-02-18T21:52:08.467

Office 2003 – Draemon – 2010-02-19T16:22:15.240

Ok, try to reboot your machine, see if that helps. – SoftwareGeek – 2010-02-19T16:28:37.240