Loading XML Into Excel Worksheet

[mavest]

I have an application capable of creating an XML string representing worksheet data. I would like to load this data into a pre-existing Excel workbook / worksheet.

Is there a good way of doing this? Without using VBA? That is easy on the CPU time - no file IO?

I could write a VB dll where my application passes the xml string for parsing and loading into Excel, but have been wondering if Excel has any built in capability.


Thanks!!

-Mike

 

[PHV]

In Excel 2003 take a look at the Workbooks.OpenXML method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244