VBA and SOAP in Excel 2010

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

While there's a lot of googlable material I seem stuck in a mass of conflicting information about SOAP support (none, roughly) in Excel 2010.

Trying to consume a webservice and write back using VBA without the overhead and dll herding involved with managed code (VSTO and friends).

I'm sending a valid message to our server, at least I detect the exception when I send in messy headers, but I never get a returned value. Assume it is some sort of validation issue.

However I read a bit on WS Security - does this in fact make VBA incompatible with web service?

Articles/citations warmly received. Currently working through:
http://blogs.msdn.com/b/jpsanders/a...o-send-soap-call-using-msxml-replace-stk.aspx

Thanks,
Jeff
 
Back
Top