Processing XML files

[Guest]

We are in the process of extracting XML files generated
by SQL2K. Does anyone have any VBA examples of
extracting XML and populated them in a worksheet without
using DOM?

Thanks,
Tom

 

[Stephen Bullen]

Hi Tom

We are in the process of extracting XML files generated
by SQL2K. Does anyone have any VBA examples of
extracting XML and populated them in a worksheet without
using DOM?

If you have Excel 2003, you can map nodes in the XML directly to cells
or Lists in the worksheet, then import the XML text to the sheet using
ImportXML.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk