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
Inherits System.Web.Services.Protocols.SoapHeader

Private cMBHSUserNameField As String

Private cMBHSPasswordField As String

Private anyAttrField() As System.Xml.XmlAttribute

'''<remarks/>
Public Property CMBHSUserName() As String
Get
Return Me.cMBHSUserNameField
End Get
Set
Me.cMBHSUserNameField = value
End Set
End Property

'''<remarks/>
Public Property CMBHSPassword() As String
Get
Return Me.cMBHSPasswordField
End Get
Set
Me.cMBHSPasswordField = value
End Set
End Property

However I don't know how to set these two fields from my VBA code.

Suggestions?

Bob

Hi Bob,

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?

Cheers

The Frog

On Apr 26, 2:32*am, The Frog <mr.frog.to.... (AT) googlemail (DOT) com> wrote:
No success. You are the only response I have gotten.

bob

Hi Bob,

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.

Cheers

The Frog

On Apr 26, 4:25*pm, The Frog <mr.frog.to.... (AT) googlemail (DOT) com> wrote:

ANYONE have experience using generated soap classes to access a web
service using VBA?????

Bob

Hi Bob,

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.

Cheers

The Frog