How to use VBA and Web Service References add-in to create soap call with SOAP header authentication Options
Bob Alston
http://groups.google.com/group/microsoft.public.xml.soap/browse_thread/thread/560a8c872cf5de96#
Gregory A. Beamer
news:3ffe669c-22df-4689...@k4g2000yqb.googlegroups.com:
> Please take a look at my post on microsoft.public.xml.soap
>
> http://groups.google.com/group/microsoft.public.xml.soap/browse_thread/
> thread/560a8c872cf5de96#
With VBA, using XmlHttp, you have to set up your own authentication header.
Here is a stack overflow question that hits on the issue:
http://stackoverflow.com/questions/1358550/xmlhttp-request-basic-
authentication-issue
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com
*******************************************
| Think outside the box! |
*******************************************
Bob Alston
<NoSpamMgbwo...@comcast.netNoSpamM> wrote:
Yes, I am well aware of that. That is exactly my question: HOW to
establish that header????
Bob
Gregory A. Beamer
ad8abe...@k26g2000vbp.googlegroups.com:
> Yes, I am well aware of that. That is exactly my question: HOW to
> establish that header????
You have two options with SOAP. One is to use setRequestHeader. This
works for many of the standard header types, like auth headers, content
type, etc. If this does not help, you often have to move deeper into the
stack, which is more easily done via a COM component than VBA itself.
If you need to actually edit the envelope rather than headers, then you
can use the SOAP Toolkit. If this is not working for you, creating the
XML for the SOAP envelope and message is a latch ditch effort.
Peace and Grace,
Bob Alston
<NoSpamMgbwo...@comcast.netNoSpamM> wrote:
> Bob Alston <bobals...@gmail.com> wrote in news:b4065d66-39cc-4db5-8659-
> ad8abe276...@k26g2000vbp.googlegroups.com:
Any chance you or someone can post an example of how to set the soap
authentication header via vba?
Bob