Hi

Is there a way to go from Excel through SOAP to a webserver? And further, is there a way to convert the returned xml into an ADODB recordset

Thanks.

Yes and yes. I believe there's a MS SOAP SDK but you could perhaps
roll your own depending on the complexity of your app.

ADO recordset can be persisted to xml and then recreated from that
xml, but the format is specific to ADO and probably will not match the
server-generated xml (unless that is from an ADO recordset). You'd
have to load the xml into a document and iterate through it, filling
the recordset.

Tim.


"MattM" wrote in message
...
Hi,

Is there a way to go from Excel through SOAP to a webserver? And
further, is there a way to convert the returned xml into an ADODB
recordset?

Thanks.

Which version of Excel? e.g.

Microsoft Office 2003 Web Services Toolkit 2.01:
http://www.microsoft.com/downloads/d...displaylang=en

Microsoft Office XP Web Services Toolkit 2.0
http://www.microsoft.com/downloads/d...displaylang=en

--

"MattM" wrote in message
...
Hi,

Is there a way to go from Excel through SOAP to a webserver?