Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Processing XML files
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Processing XML files
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interupt processing | Excel Discussion (Misc queries) | |||
data processing | Excel Discussion (Misc queries) | |||
Processing a set of Excel Files | Excel Programming | |||
Data Processing | Excel Programming | |||
Data Processing | Excel Programming |