Ado Xml

Hi
I'm trying to load a XML Domdocument into an ADO recordset so that I can load it in a spreadsheet using the CopyFromRecordset command in Excel.

But I'm getting this error message:
Recordset cannot be created. Source XML is incomplete or Invalid.

Any Ideas
Colin