VBA access to WSE web service?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have built a web service using WSE that uses "soap.tcp" as the
transport. Is it possible to access this web service from VBA using
the standard soap client (SoapClient30) (i.e. the stuff that's
included with the "Web Service References Tool")? If so, how?

When I use the "Web Service References Tool" to generate the code to
access the web service, it generates the following:
--------------------------------------------------
Private sc_ClientComponentServic As SoapClient30
Private Const c_WSDL_URL As String = "http://localhost/myapp.wsdl";
Private Const c_SERVICE As String = "ServiceName"
Private Const c_PORT As String = "ServicePort"
Private Const c_SERVICE_NAMESPACE As String = "http://tempuri.org/";
..
..
..
Set sc_ClientComponentServic = New SoapClient30
sc_ClientComponentServic.MSSoapInit2 c_WSDL_URL, str_WSML, c_SERVICE,
c_PORT, c_SERVICE_NAMESPACE
--------------------------------------------------
My web service is at "soap.tcp://localhost:8081/myapp", and that
endponit works just fine when calling from a WSE client. However, I
can't get VBA (in this case hosted in Access) to talk to it. I've
tried changing the c_WSDL_URL to "soap.tcp", but then I get an error
saying "the specified protocol is unknown."

Any help would be appreciated!

Thanks!
Brad.
.

Relevant Pages

  • Re: Help - Consuming Web Service in VBA
    ... I am after the same case of consuming a web service from VBA. ... It seems that the Web Service References Toolkit was made for Office 2003. ...
    (microsoft.public.office.developer.vba)
  • Re: WSE with web services in office
    ... > When you're calling the Web service from your Office application (Excel?) ... > are you calling the Web service from within VBA or through a VSTO solution? ... I tried specifying the soap headers I need in the generated WSDL, ...
    (microsoft.public.vsnet.vstools.office)
  • Re: Converting a Dataset to a RecordSet web services issue
    ... output of a Web Service, to a RecordSet that is usable in some VBA ... routines. ... there are a ton of references for the error "Recordset cannot ... is there a way to walk through an XML document in VBA? ...
    (microsoft.public.data.ado)
  • Re: Get data from database via web
    ... We are already getting other data into the spreadsheets with a web ... VBA already in place. ... Have the spreadsheet fetch it's data from a web service. ... Set it up so that when an email message is ...
    (microsoft.public.excel.programming)
  • 438 - Object doesnt support this property or method
    ... property or method' in my VBA Excel app that uses a web service. ... Dim CustQuery As New clsws_CustomerQuery ... I get the '438 - Object doesn't support this ...
    (microsoft.public.vb.general.discussion)