How to get number of books in a bookstore?
Const XMLDataFile = "C:\TestData.xml" Set xmlDoc = CreateObject("Microsoft.XMLDOM") xmlDoc.Async = False xmlDoc.Load(XMLDataFile)
Result is 3
Set nodes = xmlDoc.SelectNodes("/bookstore/book") MsgBox "Total books: " & nodes.Length
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!