Thanks for the reply.
We have actually already implemented XML. It works well.

We are trying to implement 3 ways of getting the data in the same tool:
ADO/OLEDB, XML, and SOAP.
We have already implemented ADO/OLEDB and XML. We have tried SOAP using Web
Services Toolkit but we have to create multiple codebasis, one for each
version of Office and it is really a pain to maintain. That's why I was
wondering if there was an easier way for SOAP.

--
Regards,
Sébastien
<http://www.ondemandanalysis.com

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


" wrote:

I find XML to be a viable approach when data must be fetch for the
users in real time and either:

1. I can't count on the users having an ODBC datasource for the DB
configured on their machine,

2. The distribution list is volatile

3. The users are OK with a Worksheet with VBA in it.

4. The users might use the data some day, but not want it in a
spreadsheet.