I would like to integrate the data returned by the CRM API into an Excel sheet. This is aimed at allowing a spreadsheet to automatically update itself through a call to the web services.So far, it looks like some VB code will be needed to handle getting a ticket and setting it on the web service call URLs. I could also parse the XML that way, but it would be nice to just use the builtin XML handling in Excel 2007 to process this data into an XML table. The format of the API records from the CRM API does not lend to well to this though, especially without any XSDs available. 

Has anyone else attempted to sove this problem, created XSDs or perhaps some XSL style sheets to transform the API results into a schema that works with the Excel 2007 XML import tools?