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

Question

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?

SoftwareGeek · Answer 1 · 2010-02-18 17:46:49Z

up vote 0 down vote

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"

answered Feb 18 '10 at 17:36

	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

feedback

1 Answer