Hi All
Can anyone please help me on my above mentioned issue i am badly in need of advice on this. Very urgent Please !!!
Also I tried with below code. I am getting below error:
"Object does'nt support this property or method: nodes.Text"
Can anyone please help me on my above mentioned issue i am badly in need of advice on this. Very urgent Please !!!
Also I tried with below code. I am getting below error:
"Object does'nt support this property or method: nodes.Text"
Code:
Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.Async = False
XMLDataFile = "C:\Users\neelakantan.lavanya\Desktop\orange.xml"
xmlDoc.Load (XMLDataFile)
Datatable.ImportSheet "C:\Users\neelakantan.lavanya\Desktop\Orange_data.xlsx", "XML", 1
Set nodes = xmlDoc.SelectNodes (Datatable.Value ("XML_Node_Assertization", Global))
Msgbox "Total count of tag is " & nodes.length
nodes.Text = "1-1Y6J4HE"