M
Michel Terrisse
Hello all,
I use Microsoft Office 2003 + Microsoft Office 2003 Web Services Toolkit 2.01
and I want to connect to a web service from Excel.
In the Visual Basic Editor I open the menu Tools/WebService References and
specify the url of the WSDL file describing the service I want to connect to :
http://mterrisse.free.fr/IndexEducation/HpSvcW.wsdl
and click on the 'Search' button.
I can see the two services HpSvcWDonnees and HpSvcWAdmin defined in the WSDL
file but when I unfold HpSvcWDonnees I can see only the port types bound to the
first port of the service (HpSvcWDonnees contains 5 ports).
If I go on and look at the code generated by the toolkit I can see
Set sc_HpSvcWDonnees = New SoapClient30
sc_HpSvcWDonnees.MSSoapInit2 c_WSDL_URL, str_WSML, c_SERVICE, c_PORT,
c_SERVICE_NAMESPACE
where c_PORT = "PortIndexMatieresParNomComplet", that is the name of the 5th
port of HpSvcWDonnees.
This means that the toolkit generated the code to access the first port of my
service only, and tries to initialize it with the name of the 5th port :-o
Is there any way to have VBA generate the code to access all the ports of the
web service ?
Note that I can correctly use this WSDL file in both Borland Delphi 2005 and
Stylus Studio 6, and access all the port types bound to all the ports of the two
services. I could also validate the WSDL using Cape Clear SOA Editor.
I only have problems to use it in VBA :-(
Thanks in advance,
Michel
I use Microsoft Office 2003 + Microsoft Office 2003 Web Services Toolkit 2.01
and I want to connect to a web service from Excel.
In the Visual Basic Editor I open the menu Tools/WebService References and
specify the url of the WSDL file describing the service I want to connect to :
http://mterrisse.free.fr/IndexEducation/HpSvcW.wsdl
and click on the 'Search' button.
I can see the two services HpSvcWDonnees and HpSvcWAdmin defined in the WSDL
file but when I unfold HpSvcWDonnees I can see only the port types bound to the
first port of the service (HpSvcWDonnees contains 5 ports).
If I go on and look at the code generated by the toolkit I can see
Set sc_HpSvcWDonnees = New SoapClient30
sc_HpSvcWDonnees.MSSoapInit2 c_WSDL_URL, str_WSML, c_SERVICE, c_PORT,
c_SERVICE_NAMESPACE
where c_PORT = "PortIndexMatieresParNomComplet", that is the name of the 5th
port of HpSvcWDonnees.
This means that the toolkit generated the code to access the first port of my
service only, and tries to initialize it with the name of the 5th port :-o
Is there any way to have VBA generate the code to access all the ports of the
web service ?
Note that I can correctly use this WSDL file in both Borland Delphi 2005 and
Stylus Studio 6, and access all the port types bound to all the ports of the two
services. I could also validate the WSDL using Cape Clear SOA Editor.
I only have problems to use it in VBA :-(
Thanks in advance,
Michel