Call WCF service hosted on Azure from Excel through VBA RRS feed

  • Question

  • Hi,

    We are trying to call WCF service hostest on azure from excel using following VBA code

    Function Check1()
    Dim addr As String
    addr = "service:mexAddress=""http://Service.cloudapp.net/AName.svc/mex"","
    addr = addr + "address=""http://Service.cloudapp.net/AName"","
    addr = addr + "contract=""IAName"", contractNamespace=""http://tempuri.org/"","
    addr = addr + "binding=""BasicHttpBinding_IAName"", bindingNamespace=""http://tempuri.org/"""

    Dim service1 As Object
    Set service1 = GetObject(addr)

    End Function

    We are getting error : Run time Error '-2147221020 (800401e4). Automation error, Invalid Syntax

    however trying with same code and using simple WCF service web role hosted on azure works fine.

    Even with local simple WCF service it works fine

    The service we are trying to call is consumed in Silverlight app. and same we want to use in excel

    Configuration of service are same i.e basic http and mex endopint have been added

    Please let us know what can be the issue

    Monday, September 17, 2012 9:58 AM


All replies