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 |
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 |
All times are GMT +1. The time now is 07:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com