Office - How to set soap header parameters when calling generated WSDL proxyclass for web service
Asked By Bob Alston on 23-Apr-11 06:20 PM
I used WSDL.exe to generate a proxy class to generate a web service
client. I then compiled it into a DLL.
The soap message required uses to parameters in the soap header. I
can see references to them in this "partial class' which was generated
Partial Public Class CMBHSAuthenticationHeader
Private cMBHSUserNameField As String
Private cMBHSPasswordField As String
Private anyAttrField() As System.Xml.XmlAttribute
Public Property CMBHSUserName() As String
Me.cMBHSUserNameField = value
Public Property CMBHSPassword() As String
Me.cMBHSPasswordField = value
However I do not know how to set these two fields from my VBA code.
The Frog replied to Bob Alston on 26-Apr-11 03:32 AM
This is a great find as fqar as I am concerned. I have not had a
chance to play with it yet, but will have a crack at it over the next
few days (or so - might have to wait for the weekend). I am not sure
of the construction of the code that you have posted or how the
designed object / class is supposed to work. I will try this with a
service that I am somewhat familiar with and see if I can make head or
tail of it.
Have you had any success since you posted this?
Bob Alston replied to The Frog on 26-Apr-11 08:33 AM
No success. You are the only response I have gotten.
The Frog replied to Bob Alston on 26-Apr-11 05:25 PM
This is a problem I have wanted to tackle for a while now. I am
looking forward to a nice intellectual challenge. I was thinking of
building a test case based on Microsoft's translation service. I will
have to dig the address up again, but I think it should make a nice
proof of concept.
Bob Alston replied to The Frog on 02-May-11 12:22 PM
ANYONE have experience using generated soap classes to access a web
service using VBA?????
The Frog replied to Bob Alston on 03-May-11 03:42 AM
I just havent had a chance to get to it yet. My weekend was taken up
by helping some friends move house, and they kind of vastly
underestimated the amount of junk...ahem goods that they had to move.
I will attempt to have a crack at it again this weekend and as far as
I know there is nothing planned except a trip to the movies (Thor!).
This isnt forgotten, I just havent had a chance to play with it yet.