Class XmlSchemas (Excel VBA)

The class XmlSchemas represents the collection of XmlSchema objects contained by an XmlMap object. To use a XmlSchemas class variable it first needs to be instantiated, for example

Dim xss as XmlSchemas
Set xss = ActiveWorkbook.XmlMaps(1).Schemas

Count

Returns a Long value that represents the number of objects in the collection.

Dim lngCount As Long
lngCount = ActiveWorkbook.XmlMaps(1).Schemas.Count

Item

Returns a single XmlSchema object from the collection.

Item (Index)

Index: The name or index number of the object.

Dim xmlschItem As XmlSchema
Set xmlschItem = ActiveWorkbook.XmlMaps(1).Schemas(Index:=1)