I'd like to do some simple substringing in Excel VBA, alas `string.substring(a,b)` does not seem to work.

I have before me a very simple xml format such as this one:

```
<result>
<rowset name="typeids" key="typeID" columns="typeName,TypeID">
<row typeName="Tritanium" typeID="34" />
<row typeName="Scordite" typeID="1228" />

```

more rows

```
</rowset>
</result>
</eveapi>

```

I'd ideally like to get an array or concatenated string with all typeIDs in the order they appear here.

Now, I could of course just `InStr` myself to death, but I'd like to know whether one of you can come up with a more elegant solution since my VBA knowledge is quite limited.

I'd also be grateful for answers that just parse the xml instead of viewing it as a simple string - I'd generally just like to keep it on the simple side since this is my first contact with VBA ever.

Thanks a lot.