Re: VBA access to WSE web service?

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Thanks for your reply Brad,
\par
\par Yes, you're right, COM interop is one possible approach as long as the client machine also has .net framework and WSE installed...
\par
\par Regards,
\par
\par Steven Cheng
\par Microsoft Online Support
\par
\par Get Secure! www.microsoft.com/security
\par (This posting is provided "AS IS", with no warranties, and confers no rights.)
\par \pard\li720 --------------------
\par From: Bradley Plett <plettb@xxxxxxxxxxxxxxxx>
\par Subject: Re: VBA access to WSE web service?
\par Date: Tue, 13 Dec 2005 09:20:55 -0700
\par Message-ID: <itstp1p6hhj237ocq17i4b3jdio58eqjsj@xxxxxxx>
\par References: <vo9rp1tqtsv0pm1ep54tg9tp92s2gu5mi1@xxxxxxx> <qXDUR14$FHA.3764@xxxxxxxxxxxxxxxxxxxxx>
\par X-Newsreader: Forte Agent 3.1/32.783
\par MIME-Version: 1.0
\par Content-Type: text/plain; charset=us-ascii
\par Content-Transfer-Encoding: 7bit
\par Newsgroups: microsoft.public.dotnet.framework.webservices.enhancements
\par NNTP-Posting-Host: s010600062595c433.cg.shawcable.net 68.144.91.204
\par Lines: 1
\par Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
\par Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.webservices.enhancements:7926
\par X-Tomcat-NG: microsoft.public.dotnet.framework.webservices.enhancements
\par
\par I'm not actually using any of the security (encryption/signing) of
\par WSE, so it's just a protocol issue. However, if TCP is not supported
\par by the object used in Office, then I'm still out of luck. Oh, well! I
\par guess my options are changing the protocol of my web service back to
\par HTTP or doing a little COM Interop.
\par
\par Thanks for your help!
\par Brad.
\par
\par On Tue, 13 Dec 2005 02:31:14 GMT, stcheng@xxxxxxxxxxxxxxxxxxxx (Steven
\par Cheng[MSFT]) wrote:
\par
\par >Hi Bradley,
\par >
\par >Welcome to webservice newsgroup.
\par >Regarding on the calling WSE protected XML Webservice through Office
\par >WebService toolkit question, based on my understanding, this is not
\par >supported due to the limitation of the Office webservice toolkit ....
\par >First, the Tcp tranport channel is specific to the WSE components while
\par >most of the webservice components only support HTTP as the transport
\par >layer......
\par >Also, even office toolkit support HTTP, since the WSE component protect the
\par >xml webservice's SOAP message by apply encryping/signing policy, this is
\par >also what office toolkit can not do so far. So I think we can only call
\par >normal xml webservice over http directly through office webservice toolkit
\par >currently...
\par >
\par >Thanks,
\par >
\par >Steven Cheng
\par >Microsoft Online Support
\par >
\par >Get Secure! www.microsoft.com/security
\par >(This posting is provided "AS IS", with no warranties, and confers no
\par >rights.)
\par >
\par >
\par >--------------------
\par >From: Bradley Plett <plettb@xxxxxxxxxxxxxxxx>
\par >Subject: VBA access to WSE web service?
\par >Date: Mon, 12 Dec 2005 09:48:34 -0700
\par >Message-ID: <vo9rp1tqtsv0pm1ep54tg9tp92s2gu5mi1@xxxxxxx>
\par >X-Newsreader: Forte Agent 3.1/32.783
\par >MIME-Version: 1.0
\par >Content-Type: text/plain; charset=us-ascii
\par >Content-Transfer-Encoding: 7bit
\par >Newsgroups: microsoft.public.dotnet.framework.webservices.enhancements
\par >NNTP-Posting-Host: s010600062595c433.cg.shawcable.net 68.144.91.204
\par >Lines: 1
\par >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
\par >Xref: TK2MSFTNGXA02.phx.gbl
\par >microsoft.public.dotnet.framework.webservices.enhancements:7916
\par >X-Tomcat-NG: microsoft.public.dotnet.framework.webservices.enhancements
\par >
\par >I have built a web service using WSE that uses "soap.tcp" as the
\par >transport. Is it possible to access this web service from VBA using
\par >the standard soap client (SoapClient30) (i.e. the stuff that's
\par >included with the "Web Service References Tool")? If so, how?
\par >
\par >When I use the "Web Service References Tool" to generate the code to
\par >access the web service, it generates the following:
\par >--------------------------------------------------
\par >Private sc_ClientComponentServic As SoapClient30
\par >Private Const c_WSDL_URL As String = "http://localhost/myapp.wsdl";
\par >Private Const c_SERVICE As String = "ServiceName"
\par >Private Const c_PORT As String = "ServicePort"
\par >Private Const c_SERVICE_NAMESPACE As String = "http://tempuri.org/";
\par \pard
\par
\par }