Receving an error when calling WCF using a Service Moniker in Excel

Question

I have a WCF webservice running that has 2 endpoints (mex and wsHttpBinding). The webservice is hostend on the address: http://localhost:2412/Service1.svc and its contact is named "WcfService1.IService1"

I want to call this service from VBA in Excel. To that, I use the folowing code:

mexMonikerString = "service:mexAddress='http://localhost:2412/Service1.svc/mex'"
mexMonikerString = mexMonikerString + ", address='http://localhost:2412/Service1.svc'"
mexMonikerString = mexMonikerString + ", binding=WSHttpBinding_IService1"
mexMonikerString = mexMonikerString + ", contract=IService1"

Set service = GetObject(mexMonikerString)

When I try to execute this code I recieve the folowing Excel error message: Run-time error '-2147221020 (800401e4)'

Does anybody know what the cause of this error is and how I can resolve it?

Answer 1

You can try to publish WCF service in your IIS.

Answer 2

Have a look at Calling WCF Services from Excel VBA clients using the WCF Service Moniker. It has a section on debugging that shows the same error code you are receiving and how to get the actual error description('Interface not found' in this case).