How to use VBA and Web Service References add-in to create soap call with SOAP header authentication

[Bob Alston]

I have been trying in vain to try to figure out how to use VBA and the
WEB Service References add-in to to allow me to send a request to a
web service that requires authentication information be presented in a
SOAP header. I had no trouble creating many functions, subroutines
and custom classes to the web service via the Web Service References
add-in. That worked slick. Seems to work but I am unable to specify
the soap authentication header. Found an email stating how to do this
via a custom IHeaderHandler module but I never could get it to work.

http://technical-domain.blogspot.com/2009/05/handling-iheaderhandler-interface.html

Also this text from the url below
"The client code generated by the Office XP WS Toolkit does not
support the DCTM authentication tokens sent in the header of the SOAP
message. In order to make the client work, we have to override the
default behavior for handling the SOAP header. This can be done by
overriding the IHeaderHandler class used by the SoapClient30 object."

See the VBA client section specifically step 4 in the link below:

http://developer.emc.com/developer/Articles/wsf/Consumers_of_the_Web_Services_Framework.htm

I couldn't make either of the above work.

Would love to hear from anyone who has solved the problem of
customizing the SOAP header for web service authentication.

Bobalston at gmail DOT c o m