How to load the XML data?
To read the XML data’s, first we have to load the XML file and then read the XML values.
E.g.,
Set xmlDoc = CreateObject("Msxml2.DOMDocument")
xmlDoc.load(“Path of the XML file”)
Set objNodeList = xmlDoc.getElementsByTagName("Value")
Set xmlDoc = Nothing ‘To release the object
E.g.,
Set xmlDoc = CreateObject("Msxml2.DOMDocument")
xmlDoc.load(“Path of the XML file”)
Set objNodeList = xmlDoc.getElementsByTagName("Value")
Set xmlDoc = Nothing ‘To release the object
Comments
Post a Comment