Excel through SOAP to a webserver

M

MattM

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.
 
T

Tim Williams

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 said:
Hi,

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