Hi;

If this is the wrong forum, please tell me which forum to hit.

I am writing a VBA applet for Excel (and Excel only). By way of
background - I have a ton of experience writing C# (including Excel
AddIns) and Java - but never Basic before.

In the text of a cell I need to parse XML fragments and then get back
the element name and some specific attributes. The string I need to
parse will be one of the following 3 forms:

<data name='dave' type='int'
<data name='dave' type='int'/
</dave

Is there an API in VBA where I can give it an XML fragment and then
get back the node name and attribute values? If so, what is the API
and anything specific I have to do to tell it that in 2 of the cases
it's an XML fragment.

Also, is this library always installed or do we need to install it if
it's not on a user's computer? This needs to run on Excel 2000, 2002,
2003, & 2007.

thanks - dave


Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm