Importing XML into an Excel 97/2000 worksheet
Posted on 2002-03-14
Hopefully a simple one.
Wonder if anyone can supply some VBA code that when run in Excel 97 will take XML from an HTTP URL source and store the entries in the worksheet cells.
<?xml version="1.0" encoding="UTF-8" ?>
<person name="Bob" siblings="2">
<person name="Anne" siblings="1">
<person name="Dave" siblings="3">
Ideally, the worksheet would be similar to,
This may sound simple in principle but I'm not even sure it can be done.
No external software or 3rd party parsers can be installed except Office 97 (or possibly 2000 at a push) and the parser that comes with IE5+.
I've had a good dig around the MSDN site but can find anything other than all the XP stuff.
To someone who knows their stuff this should be 300 easy points :-)