How do I get WSDL-request responses into Excel... WITHOUT VBA?

[jasmith4]

I need to be able to submit an XML request to a WSDL, get the XML response and deal with it. The manual way is that I go into SOAP-UI, load up a request, supply parameters, click the green triangle, get the response, and save it as an XML file. Then in Excel I import it using Data / From Other Sources / XML into a ListObject -- if I go through SOAP to re-run the same request with different parameters, I re-save the new response and refresh the ListObject. The limitation is that this XML-data-import mechanism supports only an XML file as a source, and I have to use SOAP-UI outside of Excel to run any request.

What I'd like is a way to stay in Excel, enter the parameters into cells and then refresh the ListObject -- that's it. By "refresh" I mean take care of putting the parameter values into the request, sending it, getting its response and mapping it.

The hard part is: for reasons beyond my control, VBA is completely disallowed -- otherwise I know how to bring in a reference to MSXML, construct a request with all the parameters I want, submit it, get the response string and refresh the ListObject with the string (ListObject.XMLMap.ImportXML rather than .Import).

I was thinking along the lines of a web query (an IQY file), but I can't find a way to make it send a request to a WSDL -- it seems the URL in the IQY file has to point to data in a tabular form already.

Any ideas? Thanks very much in advance.